Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
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.
Hi,
Please post ur Expression.
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)