Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nlamprecht
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
sunny_talwar

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
sunny_talwar

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)