topic SET ANALYSIS in QlikView

SET ANALYSIS

Tue, 21 Apr 2009 22:46:55 GMT

Hi,

my customer want's to decide with a button, if Set Analysis is activ or NOT.

I wrote a formel like this

if ( v_Button_Vergleich = 1,

sum

( {$ < WirtschaftsJahr = {$(#v_Vorjahr)}, WirtschaftsMonat = >}
if( InYear (%Datum_Statistik,vMaxDate,-1,2) ), BRUTTOWERT_AT1)))

, //else

sum

( if( InYear (%Datum_Statistik,vMaxDate,-1,2) ), BRUTTOWERT_AT1)

is there a other way to do this?

Thanks a lot

puwo

Wed, 22 Apr 2009 14:09:08 GMT

Hello Wolfgang,

please see the attached example.

The naming of the expression should be clear (Set Analysis or not).

Rainer

Wed, 22 Apr 2009 15:07:12 GMT

Hi,

thanks for help, but I need the solution for a lot of objects and formulars.

Is it possible to activate or deactivate SET ANALYSIS with a button ??

Thanks...