topic Re: Using dollar expansion & Variable in Expression in QlikView

Using dollar expansion & Variable in Expression

Fri, 22 Aug 2014 05:37:03 GMT

Hi! I'm having a block on creating an expression to automatically get data from the most recent quarter in a table. I know it's simple, but ... Doh!

I am using a Load statement to get a single value for the end date of most recent quarter with data.

I'm putting that in a variable varMostRecentQtr. That has the value I want (today it's - 30/06/14)

I now want to aggregate Sales Value for that qtr so I'm using

=sum({$ <EndofPeriod={$(varMostRecentQtr)}>} SalesValue)

To get the sum of the current selection with a dollar expansion of the variable. I'm clearly doing something wrong as it's not working....

Bob

tresB — Fri, 22 Aug 2014 05:55:37 GMT

Try putting single quotes around variable expansion like:

=sum({$ <EndofPeriod={'$(varMostRecentQtr)'}>} SalesValue)

PrashantSangle — Fri, 22 Aug 2014 06:06:24 GMT

Hi,

Try this,

=sum({$ <EndofPeriod={"$(=varMostRecentQtr)"}>} SalesValue)

=sum({<EndofPeriod={"$(=varMostRecentQtr)"}>} SalesValue)

Fri, 22 Aug 2014 06:24:05 GMT

Thanks, both - I knew it would be something simple!! I *hate* the intricacies of the set editor - there should be a wizard!