Percentage line chart issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone!

First of all, thank you so much for reading my post and potentially help me figure this out!

I am trying to create a chart that shows the percentage of fruit consumed throughout the day between different groups. I have figured out how to many the chart (having the dimensions be listed as: 'hour' , 'group_of_campers' and then the expression be

"sum(fruit_count)/sum(total <group_of_campers> fruit_count)").

However, when I select on a particular hour, the percentage in the graph changes to be 100%. I would like it to remain being the percentage that is actually consumed, so if 50% is consumed at noon, when I select at noon, the chart would still show 50% (not the 100% because noon is selected).

I think I might need to use set analysis for this, but am still not entirely sure how to set this up. Any and all help would be most appreciated!

Thanks!

Re: Percentage line chart issue

sunny_talwar — Fri, 03 Mar 2017 13:00:03 GMT

I think all you need is to ignore selection in Hour field for your denominator expression

Sum(fruit_count)/Sum({<hour>}TOTAL <group_of_campers> fruit_count)

topic Percentage line chart issue in QlikView

Percentage line chart issue

Re: Percentage line chart issue