Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

what is use of set analysis in qlikview?

Hi,

in qlikview what is use of set analysis

3 Replies
petter
Partner - Champion III
Partner - Champion III

Set Analysis or better Set Expressions is an extension to the expression syntax that can be used within aggregation functions to further select sets of rows and sets of elements that should be included or excluded before the aggregation should be performed. Furthermore the Set Expressions also allows the use of set operators both between record sets and element sets.

Set Analysis is what one calls the QlikView Analysis when you have used one or more set expressions. It seems for some strange reason that the term Set Analysis rather than Set Expression is what is used most often. I find this a bit odd.

The best definition is what you find if you hit F1 and look up Set Analysis:

Aggregation functions by default aggregate over the current selection of field values. The current selection can be referred to as a set of field values. You can define other sets of field values and use them in your charts instead of the current selection. For example, in a dashboard you may want to show market share a product across all regions irrespective of the current selections.

Defining a set of field values is referred to as defining a set expression and using set expressions to analyze data is referred to as set analysis.

petter
Partner - Champion III
Partner - Champion III

The short answer is:

To have a more expressive tool to do exactly the calculations and selections you want via the expression language within aggregation functions in your application.

Before Set Expressions (Set Analysis) you would have to do much more complex data modeling and pre-calculations to achieve the same with less flexibility and interactivity.

swuehl
MVP
MVP

It seems you like 'What is ...' questions a lot...

But why do you ask the same answer twice:

what is use of set analysis?

And why don't you comment on the existing answers?