Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Josh
Contributor II
Contributor II

Discrepancy of Line Graphs

Hello! 

We have not been able to figure this out at my workplace, so I am bringing it up to the community. 

Scenario: I am trying to provide visuals for our customers who view our web page and then interact(engage) with our webpage.

Graph 1:  a line graph showing two lines over time. 

                        Line one: Count of unique Page Views

                        Line two: Count of unique Engagement with the webpage (hitting a play button, interacting with media...etc) 

Graph 2: a line graph showing the ratio of engagement to page views. (Number of unique engagements divided by unique page views). 

 

The crazy part is that when I hover over both these graphs....The ratio does not = the correct answer when the "exact date" is not selected. See attached images for better description. Without Selecting the Date (Not working)Without Selecting the Date (Not working)With selecting the date (Working)With selecting the date (Working)

Labels (2)
1 Reply
dwforest
Specialist II
Specialist II

If you are using continuous scale your ratios are averaging in the roll-up and your measure is not using an Aggr() to calculate by the date

Don't use a continuous scale or use an Aggr()