topic Re: Set Analysis - last 7 days in QlikView

Set Analysis - last 7 days

Giselle100 — Sat, 16 Nov 2024 21:44:37 GMT

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.

Re: Set Analysis - last 7 days

albert_guito — Wed, 12 Dec 2018 12:50:19 GMT

Try with

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

Ag+

Re: Set Analysis - last 7 days

Giselle100 — Wed, 12 Dec 2018 12:56:39 GMT

It's returning a zero value.

Re: Set Analysis - last 7 days

sunny_talwar — Wed, 12 Dec 2018 13:11:04 GMT

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.