Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Percentage line chart issue

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!

1 Solution

Accepted Solutions
Highlighted

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)

View solution in original post

1 Reply
Highlighted

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)

View solution in original post