Discussion Board for collaboration on QlikView Layout & Visualizations.
I have created a chart having Value and percentage in same Bar as shown below by dual function.
But as i was asked to project the same without the dual function.
Used by Me:
=dual (num(Sum(Margin)/100000,'##,##0.00L') &' - '& num(Sum(Margin)/Sum(all Margin),'0.00%') ,Sum(Margin)/100000)
Please can anyone help me on he above.....
Thanks in Advance,
You can try like this,
For this you need to create 2 expressions.
2. =(sum(Sales) &'
'& Num(sum(Sales)/sum(TOTAL Sales),'##0.0%'))
Then you need to Group these expressions and for the second expression check 'Relative check box', and uncheck 'Bar'.
And choose % sign in the number tab for the 2nd expression.
Make sure to enable 'Values on Data Point' in expression tab for both the expressions.
Hope this will help you.