topic Alternate state with if statement in QlikView

Alternate state with if statement

Mon, 05 Aug 2013 09:48:46 GMT

Hi Everyone

I have a list box 'A' in alternate state 'State 1' and a list box 'B' in inherited state. I want that the values in my list box 'B' should be based on the value selected in list box 'A'. I am using the following expression in list box 'B'

if(A= maxstring({[State 1]}A), B)

But i am getting nothing in my list box 'B'.

Am i doing something wrong? If yes, please tell me how to correct it.

Re: Alternate state with if statement

tresB — Mon, 05 Aug 2013 09:56:43 GMT

Why don't you take list box B in State1 as well?

Re: Alternate state with if statement

Mon, 05 Aug 2013 10:24:59 GMT

Hi tres qv

Actually i have another list box 'C' which is in default state and i have to use this list box also in the expression. Something like

if(A= maxstring({[State 1]}A) and C= getfieldselections(C), B)

If i will take list box B in state 1, then also i will have to use both the states in my expression.