Set Analysis - Date Range (defined by variables)

Irishtone — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have searched around the forums here and tried various versions of solutions to this issue but none seem to work for me.

I am trying to set up set analyses that will show me sales this week, last week,the week before that...etc

From these I will create run rates and various other things.

My issue is that when I drop in my test variables (These are names purely for testing btw)
"v1WeeK" Defined as =Date(Max(invoice_date)-7) (In a text box, this is displaying the correct date)

"vMaxDate" Defined as =Date(Max(invoice_date)) (In a text box, this is displaying the correct date)

Into the following expression :

=sum ( { <invoice_date = {'>= $(=v1Week)<=$(vMaxDate)'} >} Qty )

I am getting the same result as "=Sum(Qty)"

Any ideas at all ?

I've got fistfuls of hair all around my desk...

Thanks
Tony

Re: Set Analysis - Date Range (defined by variables)

sunny_talwar — Mon, 28 Jan 2019 14:43:02 GMT

Try some variations of your expression

=Sum({<invoice_date = {">=$(=$(v1Week))<=$(=$(vMaxDate))"}>} Qty)

=Sum({<invoice_date = {">=$(=v1Week)<=$(=vMaxDate)"}>} Qty)

Re: Set Analysis - Date Range (defined by variables)

Irishtone — Mon, 28 Jan 2019 15:01:35 GMT

...My Hero Sunny!

The second option works a treat!

Thank you so much!

topic Re: Set Analysis - Date Range (defined by variables) in QlikView

Set Analysis - Date Range (defined by variables)

Re: Set Analysis - Date Range (defined by variables)

Re: Set Analysis - Date Range (defined by variables)