Re: Dynamic Format in Bar chart - Qlik Community

Nagaraju_KCS · ‎2018-01-04

Hi Community,

I have developed one chart based variable selection it will change the SalesAmount and Sales%.

Expression 1:

Sum(Sales)

Expression 2:

Num(Sum(Sales)/Sum(Total Sales), '##,#0.00%')

Note: Num format not working, like showing 0.63. I have to convert into 63%

these expression's changing based on toggle button. (Amount and Percentage)

In Qlikview NUM format works fine, but qlik sense not working.

but not working..

Please anyone can help me....

Thanks in Advance....

Nagaraju_KCS · ‎2018-01-04

single expression working fine

NUM(Sum(Sales)/Sum(TOTAL Sales),'##,##0.00%')

But my expression like,

If(Category='A', Sum(Sales), Num(Sum(Sales)/Sum(Total Sales), '##,#0.00%'))

this else part not converting percentage...

Anonymous · ‎2018-01-04

Try doing like this

In measures tab->number formatting-> give measure expression

Nagaraju_KCS · ‎2018-01-04

Based on selection Integer and Percentage.

If i click Integer i want to show Sales number

Percentage i want to show Sales percentage....

Anonymous · ‎2018-01-04

I have attached an app for reference. I'm getting the results you specified.

Nagaraju_KCS · ‎2018-01-04

HI Aparna,

You didn't get my point... I'm also getting like this.....

if you use or not that NUM format that will show 0.16 like ....

I want to show 63% in chart..

see here, i have used single expression..

Num(Sum(Sales)/Sum(total Sales),'##,#0.00%'), showing exactly what i want... (63.26%, 16.62%.....etc)

hope you understand....