topic Help with Alternate States in QlikView

Help with Alternate States

Sun, 07 Feb 2016 20:22:29 GMT

Hi Community,

I have a situation here where I Have 2 list boxes A and B in State1 and Same list boxes in State2.

I need to retrieve the Maximum value of the B when i select in List box A in State 1 and Similarly for the State 2.

and I want them to show it in a Textbox like below.

Thanks,

Walter

sunny_talwar — Sun, 07 Feb 2016 23:49:34 GMT

May be this:

Max value of B in State1 -> Max({[State1]}B)

Max value of B in State2 -> Max({[State2]}B)

swuehl — Mon, 08 Feb 2016 00:53:18 GMT

= 'The maximum value of ' & Only({State1} A) & ' is ' & Max({State1} B) &

' and the maximum value of ' & Only({State2} A) & ' is ' & Max({State2} B)

In general, the aggregations are just done like in default state, with alternate states added as set identifier in set analysis.