QlikView Set Analysis allows you to perform flexible aggregation. Usually aggregation occurs on the set of values in the current selection. But many a times business requirements demand to perform aggregation on a Set of records that are independent of current selection. For e.g. your current selection may be Year = 2001, but using set Analysis you can […]
In QlikView, Alternate States are not accessible in the load script.They are a feature of User interface. To use/create Alternate state, user have to first create Alternate state in Settings/Document properties. Once an Alternate state is created then user can either use this alternate state in any sheet object or create new ones. If Alternate State is […]
Today I want to discuss Alternate states in QlikView, but before we start on Alternate states, we need to understand Attach/detach functionality in QlikView. In QlikView, data is associated based on the common field names in one or more table. For e.g. If you have 3 Tables, when a selection is made in one table, […]
In any Dashboard,Time is an important factor. Users will always be interested in viewing the data by time period and also will be interested in performing comparitive analysis between 2 time periods. In a data warehouse, a Time dimension table is usually present, which joins to the fact table and produces results.In some situations, time […]
In Qlikview it is always advisable to minimize the number of tables in the data model. Mapping Tables are used in QlikView to clean up the data model. Tables with just 2 columns can be removed and columns of that table can be mapped to another table. Mapping tables are stored in a separate area […]
I’m working as an S/W Tester.Your articles and tutorials (...)
Vinoth: We provide QlikView Training. This training will (...)
Excellent training by Chandraish. Highly knowledgeable. He (...)
hello iam vinothkumar from india.iam looking for qlikview (...)
It's a shame that there is not more flexibility about the (...)
US Office : +1 614 398 0454 ; 404 626 0379
: