topic Re: Set analysis alternate states in QlikView

Set analysis alternate states

Sun, 30 Aug 2015 05:13:08 GMT

I am not getting Set analysis alternate states scenario .. Somebody please tell me about Set analysis alternate states scenario please send me step by step procedure for Set analysis alternate states send me sample data also

Thank you...:-)

Re: Set analysis alternate states

sunny_talwar — Sun, 30 Aug 2015 05:27:12 GMT

Attaching a sample with Alternate State and Without Alternate State:

Regular Expression:

=Sum({<WeekYear = {"=Num(Only({<WeekYear = >}WeekYear)) >= Max(TOTAL WeekYear) - 11 and

Num(Only({<WeekYear = >}WeekYear)) <= Max(TOTAL WeekYear)"},

Date = , Week, Year = , Month = , Day = , MonthYear = , Quarter =>} Value)

AS Exp: Name of the alternate state is AS

=Sum({AS<WeekYear = {"=Num(Only({AS<WeekYear = >}WeekYear)) >= Max({AS}TOTAL WeekYear) - 11 and

Num(Only({AS<WeekYear = >}WeekYear)) <= Max({AS}TOTAL WeekYear)"},

Date = , Week, Year = , Month = , Day = , MonthYear = , Quarter =>} Value)

First expression will driven by WeekYear list box and Second expression will be driven by WeekYear AS (this list box is in the alternate state)

HTH

Best,

Sunny

Re: Set analysis alternate states

Sun, 30 Aug 2015 05:31:18 GMT

thank you

Re: Set analysis alternate states

ecolomer — Sun, 30 Aug 2015 05:42:23 GMT

See this example:

Re: Set analysis alternate states

ecolomer — Sun, 30 Aug 2015 08:34:44 GMT

And this

Re: Set analysis alternate states

Mon, 31 Aug 2015 07:18:33 GMT

i did not get any scenario please verify and attach again scenario send me