Dynamic Format in Bar chart

[Nagaraju_KCS]

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.

I have read this document... https://community.qlik.com/thread/161478

but not working..

Please anyone can help me....

Thanks in Advance....

[OmarBenSalem]

Try as follow please:

Num(Sum(Sales)/Sum(Total Sales), '# ##0,00%')

[satishkurra]

ALso this

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

Also make sure you specify the format on right pane to Auto

If doesn't work try custom format and specify the format as

#,##0%;(#,##0%)

• Dynamic Format in Bar chart

[Nagaraju_KCS]

Single expression wise working fine...

My expression like

IF(vNumber=1, Sum(sales),  Num(Sum(Sales)/Sum(Total Sales), '##,#0.00%'))

I have one list box like NUMBER and PERCENTAGE

if i make selection NUMBER, i want to show Sales Amount,

same as PERCENTAGE, want to show Sales Percentage.

Dimension: Category

Expression: IF(vNumber=1, Sum(sales),  Num(Sum(Sales)/Sum(Total Sales), '##,#0.00%'))

Hope you understand......!!

[Nagaraju_KCS]

Custom Format it won't work, because i have IF, ELSE condition in expression

[OmarBenSalem]

can u please share a 'test' application?

[Nagaraju_KCS]

PFA,

Please have a look below image, I want to show like 22%, 50%, 28%.....

[OmarBenSalem]

what's the version u're using?

It works fine for me (and I havn't done anything to ur app):

[saniyask]

Hi,

please refer to the attached application

Regards,

Saniya

[saniyask]

You can try this in the expression If(Selection='Number', Sum(sales), Sum(sales)/Sum(Total sales)) and in the number format choose Custom format --> Format pattern --> ##,#0.00% or ##,#0%

Regards,

Saniya