topic Re: Set Analysis with variables in QlikView

Set Analysis with variables

jorgelardi — Wed, 25 Nov 2020 16:16:04 GMT

I want to use a variable in my Set Analysis.

I created the variable Tomorrow by defining it as Today () + 1

Then I use the following expression:

= Sum ({$ <delivery_date = {'$ (= Tomorrow)'}>} QuantityProduction) but I can not get consistent values

Can someone help me?

Jorge

Re: Set Analysis with variables

Anil_Babu_Samineni — Sun, 02 Jul 2017 01:36:46 GMT

May be this?

= Sum ({$ <delivery_date = {'$ (Tomorrow)'}>} QuantityProduction)

Remove = symbol in variable or use two $ symbol around variable

Re: Set Analysis with variables

passionate — Sun, 02 Jul 2017 06:44:54 GMT

Try Using

= Sum ({$ <delivery_date = {"=$ (= Tomorrow)"}>} QuantityProduction)

Re: Set Analysis with variables

vishsaggi — Sun, 02 Jul 2017 18:49:36 GMT

What is your date format for your delivery_date?

= Sum({< delivery_date = {"$(=Date(Tomorrow, 'Yourdeliverydateformat here')"} >} QuantityProduction) like

= Sum({< delivery_date = {"$(=Date(Tomorrow, 'MM/DD/YYYY') " } >} QuantityProduction)

Re: Set Analysis with variables

jcampbell474 — Mon, 03 Jul 2017 01:30:36 GMT

You can try this:

In the load script or variable editor:

Let Tomorrow = Date(Today(1)+1)

Expression:

=Sum ({<delivery_date = {'$(Tomorrow)'}>} QuantityProduction)

Re: Set Analysis with variables

jorgelardi — Mon, 03 Jul 2017 14:46:15 GMT

Thanks for your help, but it throws me a zero value

Re: Set Analysis with variables

jorgelardi — Mon, 03 Jul 2017 14:48:53 GMT

Thanks for your help, but while it gives me correct results for the Tomorrow variable, it gives me the same results for the variable Past Tomorrow which is incorrect

Re: Set Analysis with variables

jorgelardi — Mon, 03 Jul 2017 14:50:57 GMT

I throw the following error: "Error in set modifier ad hoc element list; ',' or ')' expected

Re: Set Analysis with variables

jorgelardi — Mon, 03 Jul 2017 14:52:24 GMT

Thanks for your help, but it throws me a zero value

Re: Set Analysis with variables

jcampbell474 — Mon, 03 Jul 2017 14:54:14 GMT

How is your date displayed? mm/dd/yyyy ???

Re: Set Analysis with variables

jorgelardi — Mon, 03 Jul 2017 14:55:28 GMT

dd/mm/yy

Re: Set Analysis with variables

vishsaggi — Mon, 03 Jul 2017 14:56:23 GMT

Did you try this?

= Sum({< delivery_date = {"$(=Date(Tomorrow, 'dd/mm/yyyy')) " } >} QuantityProduction)

Re: Set Analysis with variables

jcampbell474 — Mon, 03 Jul 2017 14:58:01 GMT

Ok, in your load script or the variable editor, try: Let Tomorrow = Date(Today(1)+1,'dd/mm/yy')

Re: Set Analysis with variables

passionate — Mon, 03 Jul 2017 15:14:07 GMT

How do you set past tomorrow value.

As, your vtomorrow = Today()+1 So, the Result of Set Analysis will always remain same

Re: Set Analysis with variables

juan_patrick — Mon, 03 Jul 2017 15:18:50 GMT

Jorge,

Después del signo $ los espacios no deben existir!

¡Saludos!

Re: Set Analysis with variables

jorgelardi — Mon, 03 Jul 2017 16:58:50 GMT

Thank you all !! I discovered my error. I had badly defined the variable Tomorrow in the script

Re: Set Analysis with variables

Anil_Babu_Samineni — Mon, 03 Jul 2017 17:26:17 GMT

Please make sure to create variables in script. And then use. Meanwhile, I would ask you to mark helpful from the thread if you feel to get as you expected.