Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

brijeshma
Contributor

Number formatting using if condition not working

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

8 Replies

Re: Number formatting using if condition not working

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.


talk is cheap, supply exceeds demand
brijeshma
Contributor

Re: Number formatting using if condition not working

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

Re: Number formatting using if condition not working

Post a small qlik sense document that demonstrates the problem.


talk is cheap, supply exceeds demand
brijeshma
Contributor

Re: Number formatting using if condition not working

i am putting qvf kindly check

Re: Number formatting using if condition not working

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.


talk is cheap, supply exceeds demand
brijeshma
Contributor

Re: Number formatting using if condition not working

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

Kindly give me solution for this

brijeshma
Contributor

Re: Number formatting using if condition not working

Hi

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

Re: Number formatting using if condition not working

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


talk is cheap, supply exceeds demand
Community Browser