Set Analysis Field= doubt

[sridhar_sigired]

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

[qlik4asif]

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,

[tresesco]

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

[arvind_patil]

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

[ramasaisaksoft]

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])

[pradosh_thakur]

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