Using variables to create date range in set analysis

Wed, 08 Mar 2017 10:45:37 GMT

I am currently trying to create a date range filter in QlikSense using set analysis and the qsVariable extension, however I am having trouble in getting this to work.

Initially I was trying:

Sum({$<

[PP.PaymentReceivedDate.autoCalendar.Date]>={$(vFrom)},

[PP.PaymentReceivedDate.autoCalendar.Date]<={$(vTo)},

StatusFlagCode = {$(vStatusFlag)}

>}[PP.ReceivedAmount])

This seemed fairly logical to me, but returned zero results. After some investigation it was suggested that I try the following:

Sum({$<

[PP.PaymentReceivedDate.autoCalendar.Date]={'>=$(=vFrom)'},

[PP.PaymentReceivedDate.autoCalendar.Date]={'<=$(=vTo)'},

StatusFlagCode = {$(vStatusFlag)}

>}[PP.ReceivedAmount])

Unfortunately this also does not work, and it appears that the variable is not recognized within, as it in enclosed within quotation marks:

Any suggestions would be appreciated!

James

Re: Using variables to create date range in set analysis

Wed, 08 Mar 2017 11:03:47 GMT

So it looks like the following works in this situation:

[PP.PaymentReceivedDate.autoCalendar.Date]={"$(= '>=' & date(vFrom) & '<=' & date(vTo))"},

The script editor still doesn't highlight the variables here, but it works in practice!

topic Using variables to create date range in set analysis in QlikView

Using variables to create date range in set analysis

Re: Using variables to create date range in set analysis