Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Irishtone
Contributor II
Contributor II

Set Analysis - Date Range (defined by variables)

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

1 Solution

Accepted Solutions
sunny_talwar

Try some variations of your expression

1)

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

or

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

View solution in original post

2 Replies
sunny_talwar

Try some variations of your expression

1)

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

or

=Sum({<invoice_date = {">=$(=v1Week)<=$(=vMaxDate)"}>} Qty)
Irishtone
Contributor II
Contributor II
Author

...My Hero Sunny!

The second option works a treat!

 

Thank you so much!

T