Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have an expression for % , how can i display the total value and percentage both on the bar chart below.
Below is the expression
=Num(
Count({<[STATUS]={"COMPLETED"}>}[STATUS])
/
Count({<[TECH]={"POSTGRES","ORACLE","MONGO"}>}[TECH])
, '#.%')
Use Dual as expression with Numeric value and text value. and select Value on data point option.
e.g.
expression =Dual(Num(Sum(Sales)/Sum(Total Sales),'###.#%'),Sum(Sales))
Did Dilip's comment solve things for you? If so, be sure to use the Accept as Solution button on his comment to give him credit... If you are still struggling, here are a couple of links that expand upon his idea:
https://community.qlik.com/t5/Qlik-Design-Blog/Dual-Exists-Useful-Functions/ba-p/1465290
Regards,
Brett