Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am good with QlikView but not with Set Analysis. I was trying to understand why many people use Field= in set analysis expression and tier to find this information in community, but did not get.
Can anyone explain or help to me get links to study?
Thanks,
Sridhar
Fields are called modifiers in set expressions
Eg:
={$<Year={2009}>}
It are referenced to field based on which u want output
In the above expression we can see data related to year 2009
It is similar like filtering with field values and also we can include many values and many fields under one espression.
Thaks,
You can start learning set analysis from HELP itself. There are some good resources available here in community as well you can refer. One is :Set Analysis: syntaxes, examples
Hi Sridhar,
Which is Used for nullification purpose. Means you have select any value on that field that selection not applied for that set.
for Ex:
Sum({<Year=>}Sales)
In above example if you select year 2017 or else then also it shows same result .
means Selction not applied with that particular field.
Thanks,
Arvind patil
Hi,
Means bypassing the selections of that field.
ie, It will consider the total data of that field regardless of selections.
Ex:-
suppose you have 3 filters/List boxes in QV dashboard(Dim 1,Year, Month)
even though user selects these 3 filters, your expression need to be calculate only for 2 filters year,Month then you need to write like below.(here we by pass the Dim 1 filter selections,i mean ignore selections in the Dim 1 values into this expression)
Just add Dim1= in set Analysis it excludes the selection of this field in set analysis,
=sum({<Dim1 =, Year={$(vCurrentYear)},Month={$(vCurrentMonth)}>}[Gross Amount])
Hi
credit goes to the creator of this document. Its really nice and handy and almost covers each and every thing about set analysis.
happy Qliking.
regards
Pradosh