Number formatting using if condition not working

[brijeshvma]

Hi All,

i have created inline ,

TrendView:

Load * Inline [

%View, Format

Number , 1

Percent,  2

];

And say i have expression like

if (format = 1 ,Sum(Aggr(Bounces,VisitFull)) ,Num((Sum(Aggr(Bounces,VisitFull))/Sum(Aggr(Visits,VisitFull))),'#,##0.00%')

)

and created a List box for View Number , format

if i select Number is shows the value and if i select it showing value but not percentage calculated and without % sign..

if am i putting an expression Num((Sum(Aggr(Bounces,VisitFull))/Sum(Aggr(Visits,VisitFull))),'#,##0.00%')   without if condition

it working fine...

can any one help me to sort out this

[Gysbert_Wassenaar]

format and Format are two different fields. Make sure to use the correct case sensitive field name.

And make sure not to overrule the expression format on the Numbers tab. Leave the setting for the expression to Expression Default.

[brijeshvma]

hi Gysbert ,

Sry , i am writing

if (Format = 1 ,Sum(Aggr(Bounces,VisitFull)) ,Num((Sum(Aggr(Bounces,VisitFull))/Sum(Aggr(Visits,VisitFull))),'#,##0.00%')

)

Only ... but its not working

[Gysbert_Wassenaar]

Post a small qlik sense document that demonstrates the problem.

[brijeshvma]

i am putting qvf kindly check

[Gysbert_Wassenaar]

I'm afraid Qlik Sense doesn't honor the % format in the num function yet in bar charts. I can't get it to work either.

[brijeshvma]

Without if Condition i am able to do % Format..

Kindly give me solution for this

[brijeshvma]

Hi

Can u help me on this .. how to resolve this

[Gysbert_Wassenaar]

See attached qvf. That's the best I can do at this time.

[qlikdelqbz]

Unfortunately it still does not work. Any one has better solution? Thanks.