Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
I think Qlik Sense 3.2.
but not working my end..
Please see above post...
I have two options Number and Percentage..
if you give Custom format.. number also ll show in percentage...
Use the num(FieldName,'###.0%;(###.0%)') in your expression THEN in the Measure properties >> Number Formatting >> select Expression measure