Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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))