Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
Please post ur Expression.
if you are working at the script level then check for
Switch Functionality in Qlikview Help..
else if you are working to write in expression then check check for
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)