topic Re: Set Analysis By pass in QlikView

Set Analysis By pass

Sun, 16 Nov 2014 16:51:15 GMT

Hi All,

I have written a set analysis code to get the current month, current year gross amount. The answer is correct, however when I select the filter Dim1 the value changes. Is there a way to keep the value constant even when I click on the Dim1 filter.

Attached the qvw file.

Thanks in Advance.

Re: Set Analysis By pass

MK_QSL — Sun, 16 Nov 2014 16:52:46 GMT

=sum({<Dim1 =, Year={$(vCurrentYear)},Month={$(vCurrentMonth)}>}[Gross Amount])

Simply in Set Analysis, whatever you want to bypass...use

Field1 = , Field2 = , etc

Re: Set Analysis By pass

jagan — Mon, 17 Nov 2014 03:17:42 GMT

Hi,

Just add Dim1= in set Analysis it excludes the selection of this field in set analysis,

=sum({<Dim1 =, Year={$(vCurrentYear)},Month={$(vCurrentMonth)}>}[Gross Amount])

Hope this helps you.

Regards,

jagan.

Re: Set Analysis By pass

ashfaq_haseeb — Mon, 17 Nov 2014 05:11:38 GMT

Hi,

Use below

=sum({<Year={$(vCurrentYear)},Month={$(vCurrentMonth)},Dim1=>}[Gross Amount])

=sum({<Dim1=>}[Gross Amount])

Have a look at attached application too.

Regards

ASHFAQ