topic Re: Varaiables in QV12 in QlikView

Varaiables in QV12

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

G'day,

I'm having some problems after upgrading to ver 12. I'm running November SR2 Release.

I have a report that read data from a variable but does not work any more

=Sum({<SA_DATE1={'<=$(VmaxDate)'}>} CALC_QTY)

the varaiable VmaxDate is:

=DATE(Max(SA_DATE),'DD/MM/YYYY')

When I'm putting the varaiable in a Text object I can see the max date correctly.

In Qlikview 11 it's working correctly.

Any help will be appreciated

Thanks

Yaniv

Re: Varaiables in QV12

Anil_Babu_Samineni — Sun, 04 Feb 2018 12:43:05 GMT

Please change Single Quote to Double Quote?Qlik Design Blog

Re: Varaiables in QV12

egoziyan — Sun, 04 Feb 2018 12:48:15 GMT

Thanks Anil for the quick replay

Double quotes did not work as well

=Sum({<SA_DATE1={"<=$(VmaxDate)"}>} CALC_QTY)

Re: Varaiables in QV12

Anil_Babu_Samineni — Sun, 04 Feb 2018 12:55:22 GMT

Please try this without variable? And let me know

=Sum({<SA_DATE1={"=SA_DATE1<=DATE(Max(SA_DATE),'DD/MM/YYYY')"}>} CALC_QTY)

OR, Create one statement using this?

If(SA_DATE1<=DATE(Max(SA_DATE),'DD/MM/YYYY'), 1,0) as Flag

And, Create this measure instead yours

Sum({<Flag = {1}>} CALC_QTY)

Re: Varaiables in QV12

egoziyan — Sun, 04 Feb 2018 13:00:50 GMT

=Sum({<SA_DATE1={"=SA_DATE1<=DATE(Max(SA_DATE),'DD/MM/YYYY')"}>} CALC_QTY)

Work

Re: Varaiables in QV12

Anil_Babu_Samineni — Sun, 04 Feb 2018 13:02:36 GMT

Now try this?

=Sum({<SA_DATE1={"=SA_DATE1<=$(VmaxDate)"}>} CALC_QTY)

Re: Varaiables in QV12

egoziyan — Sun, 04 Feb 2018 13:13:29 GMT

That did not work

Re: Varaiables in QV12

Anil_Babu_Samineni — Sun, 04 Feb 2018 13:15:10 GMT

May be this?

=Sum({<SA_DATE1={"=SA_DATE1<=$(=VmaxDate)"}>} CALC_QTY)

Re: Varaiables in QV12

egoziyan — Sun, 04 Feb 2018 13:16:54 GMT

Re: Varaiables in QV12

Anil_Babu_Samineni — Sun, 04 Feb 2018 13:19:26 GMT

Will you able to share application to investigate?

Re: Varaiables in QV12

egoziyan — Sun, 04 Feb 2018 13:21:38 GMT

Let me see what I can do because the app is 1.5GB

Re: Varaiables in QV12

Anil_Babu_Samineni — Sun, 04 Feb 2018 13:23:36 GMT

I provided link which is very advanced if you have QV12.20 SR2/5 installed. Please make clear

Re: Varaiables in QV12

rwunderlich — Sun, 04 Feb 2018 17:39:05 GMT

To debug, put the expression in a straight table and leave the Expression Label blank. The column heading will show the expression text after the $() expansion. Does the expression look as you expect?

-Rob