Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ishafate
Contributor
Contributor

Wrong data is shown on line chart when no date is selecte

Hi i have the below line chart which shows the % female and Male 

the data is wrong when no date is selected , however when I select a date form the x axis i.e Feb 2021 in this example the data is correct and there is a huge difference. Can anyone help please?

 

My expression is : 

Count(distinct(id))/
Count(distinct TOTAL(id))

Labels (1)
1 Reply
BenjaminT
Partner - Creator
Partner - Creator

It is because your denominator is counting distinct IDs across all months. Try the following:

Count(distinct(id))/
Count(distinct TOTAL <Month> (id))