Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to count remaining data

Hello All,

I have an issue regarding counting the remaining data.

ex.

on default it show 41 users who have logged in but after selecting a particular date it shows 40 user logged in.

Now I want to see the count of the remaining user and also after clicking it to show the user who have not logged in on that dat.

pls do help.

Regards.

1 Solution

Accepted Solutions
sunny_talwar

One option could be

Count(DISTINCT {1} Users) - Count(DISTINCT Users)

or

Count(DISTINCT {1-$} Users)

View solution in original post

6 Replies
Anonymous
Not applicable
Author

Hi

Assuming Date and User are your fields

Try this in Text box

=if(Aggr(Sum(1),Date)>0,

                      'Selected: $(=Count(DISTINCT (users))',

                  'Others: $(=Count({<Date=E({$} date)>} Users))’)






or





Try this is in  Pivot table (For Remaining Users)


count(Distinct {<Date = E({$} Date)>} Users)

sunny_talwar

One option could be

Count(DISTINCT {1} Users) - Count(DISTINCT Users)

or

Count(DISTINCT {1-$} Users)

Anonymous
Not applicable
Author

You have always out of box ideas.....!!!

Not applicable
Author

Thanks the first one worked for me.!

sunny_talwar

sunny_talwar

Yes, I was not very confident about the second expression myself (that's why listed it second). But I am glad 1st one worked for you

Best,

Sunny