topic Re: Variables in Set analysis in QlikView

Variables in Set analysis

Mon, 27 Jul 2015 17:08:18 GMT

Good afternoon community,

I still find it difficult to get variables within set analysis to work.

I am trying to get sum of sales for prior year, and have set up the variable as such.

The outcome of the variable is: "15 | 2014"

I then insert the variable into the below formula, but can't get the syntax right

=NUM(SUM({1<%Date_Period={'=$(vPriorYear'}>}Sessions),'###,###.')

The below formula works ok, and gives a result:

=NUM(SUM({1<%Date_Period={'15 | 2014'}>}Sessions),'###,###.')

Any help will be greatly appreciated, I've gone round in so many circles!!

Thanks,

Simon

Hi all, I've tried what you suggested, but still stuck - I'm not sure if it is the way that I have written the variable, but I can't pinpoint why it won't work for me. Thank you for your advice so far, Simon

Re: Variables in Set analysis

Gysbert_Wassenaar — Mon, 27 Jul 2015 17:15:56 GMT

Can you post a qlikview document that demonstrates the problem?

Re: Variables in Set analysis

marcus_sommer — Mon, 27 Jul 2015 17:16:19 GMT

‌There is a parenthesis missing after your variable.

Re: Variables in Set analysis

ecolomer — Mon, 27 Jul 2015 17:16:38 GMT

See this examples:

Re: Variables in Set analysis

Mon, 27 Jul 2015 17:20:05 GMT

Hi Simon,

Try this....

=sum({<Date_Period={'$(vPriorYear)'}>}Sessions)

Regards,

Rakesh

Re: Variables in Set analysis

qlikviewwizard — Tue, 28 Jul 2015 02:02:49 GMT

Good info ecolomer

Thanks for sharing.

Re: Variables in Set analysis

jagan — Tue, 28 Jul 2015 02:29:51 GMT

Hi Simon,

You missed the ) after vPriorYear, that is why it is not working, try below expression

=NUM(SUM({1<[%Date_Period]={'=$(vPriorYear)'}>} Sessions),'###,###')

Hope this helps you.

Regadrs,

Jagan.

Re: Variables in Set analysis

sasiparupudi1 — Tue, 28 Jul 2015 06:10:49 GMT

Please post your application

Re: Variables in Set analysis

svenkita — Tue, 28 Jul 2015 06:14:42 GMT

This site could be helpful for you. it help you to build the set analysis

Set Analysis Wizard for QlikView | qlikblog.at

Re: Variables in Set analysis

qlikviewwizard — Tue, 28 Jul 2015 06:20:17 GMT

Hi simonriwatson

Can you post the application to demonstrate the issue. This will help the folks to give best solution in quickly. Otherwise answers will be given based on guessing. Thank you.

Re: Variables in Set analysis

jafari_ervin — Tue, 28 Jul 2015 06:25:23 GMT

Hi Simon,

Please try to write your variable without '=' and insert it in Double Quotation.

Also added '=' in you variable definition.

=NUM(SUM({1<%Date_Period={"$(vPriorYear)"}>}Sessions),'###,###')

Re: Variables in Set analysis

Anonymous — Sun, 13 Sep 2015 08:58:02 GMT

Dear Enrique Colomer,

Please explain, how did you created so many charts inside one box !

And also how did you created the different box tabs " Distribution Annual" "Penetration Por" "........" using the same Table!!

Many Thanks,

Re: Variables in Set analysis

ecolomer — Sun, 13 Sep 2015 09:05:28 GMT

OK,

I used a CONTAINER in order to group some objects in the same place.

And, in some graphics are TRELLIS