Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
qv_testing
Specialist II
Specialist II

Dynamic Format in Bar chart

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....



12 Replies
qv_testing
Specialist II
Specialist II
Author

I think Qlik Sense 3.2.

but not working my end..

qv_testing
Specialist II
Specialist II
Author

Please see above post...

I have two options Number and Percentage..

if you give Custom format.. number also ll show in percentage...

MabuzaDoni
Contributor
Contributor

Use the num(FieldName,'###.0%;(###.0%)') in your expression THEN in the Measure properties  >> Number Formatting >> select Expression measure