topic Re: Multiple Values for a Single Variable in QlikView

Multiple Values for a Single Variable

Tue, 04 Mar 2014 15:50:40 GMT

Possibly I am heading down the wrong road and I bow to the knowledge of the many wiser (more experienced) people.

I have a waterfall chart that assesses year on year revenue performance. In January I used Let vMonth = 'Jan' and all bar offsets worked as expected.

In February I used Let vMonth = 'Jan' .... and there it went wrong. I need to capture both Jan and Feb.

Is this possible through variables or some other smarter method to capture Jan and Feb and later months all months to October for example?

Many thanks

Rob

Re: Multiple Values for a Single Variable

alexandros17 — Tue, 04 Mar 2014 16:04:50 GMT

A variable contains only a value but this value can be a string where you store more than one information.

Add to your document the selection object and select more than one month, the string contains months and you may set a variable with that value

Hope it helps

Re: Multiple Values for a Single Variable

Carlos_Reyes — Tue, 04 Mar 2014 16:07:43 GMT

If you're defining your variable in the script then I think you're placing a static value on it... so... perhaps you need to use a formula that is recalculated on every click. The only thing I can think of...and if you need to have all Month names in that variable... why don't you use the Concat function to define it?

=Concat (Distinct Month, ',')

Check the QlikView Help (F1) for more details about this function.

Re: Multiple Values for a Single Variable

Anonymous — Tue, 04 Mar 2014 18:42:29 GMT

Here is an example how to get the list of month names from the year start to the current date
=concat({<Date={"$(= '>=' & makedate(year(today())) & '<=' & date(today()))"}>} distinct Month, ',')

Re: Multiple Values for a Single Variable

Tue, 04 Mar 2014 19:10:47 GMT

As always with Qlikview (which is why I like it so much) more than one solution to a problem.

Thanks for the guidance much appreciated - and now have a working app (again).