Qlik Sense Count Distinct rows in last week

[Anonymous]

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)

Date	Version	Site	ChangeLog	DetailID
2017-12-09	2.5	AAA	abcd	1
2017-12-09	2.3	SSS	abcd	2
2017-12-07	2.3	BBB	abcd	1
2017-11-31	2.1	AAA	efghi	3

Any help would be much appreciated.

Thanks

[sunny_talwar · Accepted solution]

This doesn't work?

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

[Anonymous]

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