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....
Try as follow please:
Num(Sum(Sales)/Sum(Total Sales), '# ##0,00%')
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%)
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......!!
Custom Format it won't work, because i have IF, ELSE condition in expression
can u please share a 'test' application?
PFA,
Please have a look below image, I want to show like 22%, 50%, 28%.....
what's the version u're using?
It works fine for me (and I havn't done anything to ur app):
Hi,
please refer to the attached application
Regards,
Saniya
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