Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Giselle100
Contributor III
Contributor III

Set Analysis - last 7 days

Hi All

 

i have this expression 

Count({<[DBN Status ID No]={12}>}distinct [Order No] ) 

I need it to only return the last weeks data. So [In Branch Date] from today and 7days back.

 

 

3 Replies
albert_guito
Creator II
Creator II

Try with

Count({<[DBN Status ID No]={12}, [In Branch Date] ={">=$(=Today()-7)"}>} distinct [Order No] ) 

Ag+

Ag+
Giselle100
Contributor III
Contributor III
Author

It's returning a zero value.

sunny_talwar

What is your in branch date field format? May be you need to add that to your set analysis as set analysis is format sensitive.... something like this

Count({<[DBN Status ID No] = {12}, [In Branch Date] ={">=$(=Date(Today()-7, 'DD-MM-YYYY'))"}>} DISTINCT [Order No])

DD-MM-YYYY was an example... make sure to use the format that you have In Branch Date stored as in your dashboard.