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: 
Anonymous
Not applicable

Qlik Sense Count Distinct rows in last week

Hi all,

I am trying to make a graph to count the number of distinct changelogs + detailID occurring in the last week.

I have these two formula's in various other parts of the app and thought I could combine the count distinct with the look for the last week, but am not having any luck.

=count(distinct ChangeLog&'-'&DetailID)


=Count({<InputType = {'Error'}, Date = {">=$(=Date(Today()-7, 'YYYY-MM-DD'))"}>} InputType)


DateVersionSiteChangeLogDetailID
2017-12-092.5AAAabcd1
2017-12-092.3SSSabcd2
2017-12-072.3BBBabcd1
2017-11-312.1AAAefghi3


Any help would be much appreciated.

Thanks

1 Solution

Accepted Solutions
sunny_talwar

This doesn't work?

=Count({<InputType = {'Error'}, Date = {">=$(=Date(Today()-7, 'YYYY-MM-DD'))"}>} DISTINCT ChangeLog&'-'&DetailID)

View solution in original post

2 Replies
sunny_talwar

This doesn't work?

=Count({<InputType = {'Error'}, Date = {">=$(=Date(Today()-7, 'YYYY-MM-DD'))"}>} DISTINCT ChangeLog&'-'&DetailID)

Anonymous
Not applicable
Author

That does seem to work, I was just having issues where to put the distinct (I was trying to put it up near the count).

Thanks for the help