Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Alternate state with if statement

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.

2 Replies
tresesco
MVP
MVP

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

Not applicable
Author

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.