Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rkpatelqlikview
Creator III
Creator III

How to count the no of sales except last 7 days

Hi,

Can anyone please explain how to count the no of sales except last 7 days from today.

Thanks in advance

1 Solution

Accepted Solutions
sunny_talwar

May be this

Count(DISTINCT {<DateField = {"$(='<=' & Date(Today() - 7))"}>} Transaction_ID)

View solution in original post

2 Replies
sunny_talwar

May be this

Count(DISTINCT {<DateField = {"$(='<=' & Date(Today() - 7))"}>} Transaction_ID)

View solution in original post

rkpatelqlikview
Creator III
Creator III
Author

Thanks Sunny.

Its working.