Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bhuprakash
Creator II
Creator II

Want to add line in combo chart with % contribution values

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. combo chart.png

2 Solutions

Accepted Solutions
jsteyn
Creator
Creator

see attached, you might need to tweak the presentation and number format to get the look you are after ,

 

hope this helps

View solution in original post

Anil_Babu_Samineni

PFA

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

8 Replies
jsteyn
Creator
Creator

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

Kushal_Chawda

You can use below expression in combo chart and represent as line

=sum( ActivityValue) /sum( total ActivityValue)

bhuprakash
Creator II
Creator II
Author

I have applied both the formulas but line chart is not coming 

jsteyn
Creator
Creator

Do you mind sharing your QVF file?

bhuprakash
Creator II
Creator II
Author

No prob. Please find attached qvf file.

jsteyn
Creator
Creator

see attached, you might need to tweak the presentation and number format to get the look you are after ,

 

hope this helps

Anil_Babu_Samineni

PFA

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
bhuprakash
Creator II
Creator II
Author

Thanks issue resolved