topic Re: Set Analysis with Variables in QlikView

Set Analysis with Variables

Thu, 23 Jul 2015 16:34:32 GMT

Probably a really simple one, but Ive gone number blind

I have a variable vpast that defines a day 4 days prior to the max day in the current selection, if I use this in a text box $(vpast) it correctly evaluates the date, now I am trying to use it in the set analysis of an expression:

=Sum({$<Date={"=$(vPast)"}>}Value)

And the displayed value is in fact sum(Value) for the selected date & not the date 4 days past. I must be missing something but not sure what?

Help appreciated!

Re: Set Analysis with Variables

swuehl — Thu, 23 Jul 2015 16:37:13 GMT

Try

=Sum({$<Date={'$(vPast)'}>}Value)

edit: and QV is case sensitive, just make sure that your variable is called vPast and not vpast as shown above

Re: Set Analysis with Variables

settu_periasamy — Thu, 23 Jul 2015 16:51:35 GMT

May be like this

=Sum({$<Date={'$(=vPast)'}>}Value)

Re: Set Analysis with Variables

sunny_talwar — Thu, 23 Jul 2015 16:55:50 GMT

Or may be this:

=Sum({$<Date={"$(vPast)"}>}Value)

Where date format for vPast is the same as Date format.

Re: Set Analysis with Variables

sasiparupudi1 — Thu, 23 Jul 2015 17:46:38 GMT

=Sum({$<Date={"$(vPast)"}>}Value)