topic Re: If condition for Percentage in QlikView

If condition for Percentage

NavinReddy — Wed, 28 Feb 2018 15:38:42 GMT

Hello All,

Below if condition its working for only numbers, when the list if I have percentage it’s not forking. Please suggest me.

if(PM=0,Num(num(CM),',###,###.00%'),Num(num((CM-PM))/PM,',###,###.00%'))

Thanks in Advance

Niranjan

Re: If condition for Percentage

YoussefBelloum — Wed, 28 Feb 2018 15:41:26 GMT

Hi,

would you be able to attach an excel file with some rows from your source ?

Re: If condition for Percentage

Ivan_Bozov — Wed, 28 Feb 2018 15:53:15 GMT

I guess you also have different field names corresponding to each of these numbers? If so, you can go like:

IF(YourDimension=FieldNameA, Num(YourExpression,'###0,0%'),

IF(YourDimension=FieldNameB, Num(YourExpression,'#.##0'),

IF(...)))

Re: If condition for Percentage

Digvijay_Singh — Wed, 28 Feb 2018 16:03:33 GMT

If you observe CM/PM number position, they are left aligned so format is text, so your condition PM=0 is not evaluating true when text value is 0.00% as its not compared numerically. May be try if Num(PM) = 0 to start your IF.