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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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))