Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Friends,
I have a variable vMaxDate=Date(Max(Date_Date),'DD/MM/YYYY') = 31/OCT/2016
and this set analysis ;- sum({$<Date_Date={"$(=vMaxDate)"},Flag={'ATTENDED DOCTOR REVENUE'}>} SELFPAYER_LC - DISCOUNT + PAYER1_LC)
it is working fine when i am working on QlikSense Desktop.
But when i am deploying this app on then Variable is showing 30/Dec/1899
and when i created a new variable there it is showing correct date but not working in the same set analysis
why ???
mto
Add an equal to sign
sum({$<Date_Date={" = $(=vMaxDate)"},
also your variable definition should have the equal sign
example it should be
=DATE(..........)
can you share sample?
Use this for variable...
Date(Max(Date#(Date_Date,'DD/MM/YYYY')))
It will show total by this way
when i am using same thing
Date(Max(Date#(Date_Date,'DD/MM/YYYY'))) direct in exp showing correct data. but while using through a variable it showing zero.
what total would you expect with Max(DATE)?? have you tried yet??
Try removing the '=' before variable in set expression like:
sum({$<Date_Date={'$(vMaxDate)'},Flag={'ATTENDED DOCTOR REVENUE'}>} SELFPAYER_LC - DISCOUNT + PAYER1_LC)
Mohit,
1) Would you explain where do you create this Variable. I mean by using Variable OverView / Script level
Explanation:
I) If you are using Variable OverView
Sum({<Date = {'$(vMaxDate)'}>} Outstanding)
For Ref, Ctrl + Alt + V
Then create vMaxDate
And the You need to define this =Date(Max(Date),'DD/MM/YYYY')
II) If Script, You can use this
SET vMaxDate = Date(Max(Date),'DD/MM/YYYY');