Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Group Members,
I want to add a line chart in combo chart with % contribution values. For example shown in the first chart. 519 activities are the 18% of total. Same I want to add in qlik chart in second image. Please help me because I am new in qlik sense.
Thanks in advance.
see attached, you might need to tweak the presentation and number format to get the look you are after ,
hope this helps
PFA
Try this:
Create a measure as "Height of Line" in your combo chart
Then:
=Aggr(sum(Measure_Field), Dimension_Field)/
sum(Total Measure_Field)
And some context:
https://community.qlik.com/t5/Qlik-Design-Blog/What-does-the-TOTAL-qualifier-do/ba-p/1472990
You can use below expression in combo chart and represent as line
=sum( ActivityValue) /sum( total ActivityValue)
I have applied both the formulas but line chart is not coming
Do you mind sharing your QVF file?
No prob. Please find attached qvf file.
see attached, you might need to tweak the presentation and number format to get the look you are after ,
hope this helps
PFA
Thanks issue resolved