Varaiables in QV12

[egoziyan]

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

[Anil_Babu_Samineni]

Please change Single Quote to Double Quote?Qlik Design Blog

[egoziyan]

Thanks Anil for the quick replay

Double quotes did not work as well

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

[Anil_Babu_Samineni]

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)

[egoziyan]

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

Work

[Anil_Babu_Samineni]

Now try this?

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

[egoziyan]

That did not work

[Anil_Babu_Samineni]

May be this?

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

[egoziyan]

No

[Anil_Babu_Samineni]

Will you able to share application to investigate?