Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Case statement


Does anyone know if there is a 'CASE' function in QlikView which evaluates a list of conditions and returns one of multiple possible result expressions ?

I need to do several 'IF()' within the same expression and I'm looking for an easy way to do it.

Thank you very much.

3 Replies
Valued Contributor II

Re: Case statement


Please post ur Expression.

Not applicable

Re: Case statement

Hi ,

if you are working at the script level then check for

Switch Functionality in Qlikview Help..

Switch..case..default..end switch

else if you are working to write in expression then check check for

ALT  function

Not applicable

Re: Case statement

In fact, I try to put 6 IF() functions in one expression which will be used in a dimension :

if(GetSelectedCount(Field1) > 0, Field1)

if(GetSelectedCount(Field2) > 0, Field2)

if(GetSelectedCount(Field3) > 0, Field3)

if(GetSelectedCount(Field4) > 0, Field4)

if(GetSelectedCount(Field5) > 0, Field5)

if(GetSelectedCount(Field6) > 0, Field6)

Community Browser