topic Re: Set Analysis Field= doubt in QlikView

Set Analysis Field= doubt

sridhar_sigired — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Set Analysis Field= doubt

qlik4asif — Mon, 09 Oct 2017 04:51:39 GMT

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,

Re: Set Analysis Field= doubt

tresB — Mon, 09 Oct 2017 05:03:06 GMT

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

Re: Set Analysis Field= doubt

arvind_patil — Mon, 09 Oct 2017 05:07:44 GMT

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

Re: Set Analysis Field= doubt

ramasaisaksoft — Mon, 09 Oct 2017 07:19:51 GMT

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

Re: Set Analysis Field= doubt

pradosh_thakur — Mon, 09 Oct 2017 08:09:48 GMT

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