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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
HhAaRrIi
Contributor
Contributor

How To Find Distinct Value In Line Chart

Hi Developer's 

 

I Just Stuck With the Issue In Line Chart

I Have Taken 2 Trend Lines 

1. Count(Email) For Total Count

2.count(Distinct Email) For Unique Count

And The Dimension Is  Day/Date .

In Trend Line It Is Showing the Distinct(Email) In Day/Date Wise,  But I Need Overall Distinct(Email) on Unique Count trend Line.

Labels (1)
2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

If you do the distinct at overall level it will show single value for each day. If you want that, you can try below expression

Count( total  Distinct Email)

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
HhAaRrIi
Contributor
Contributor
Author

Thank You Koushik