Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlikview community
I am trying to adjust a date format within a set analysis.
=Sum({$<RRTDATE={"$(=date(vBeginDate,'YYYY-MM-DD'))"}>}GROSSVAL)
The above is my formula but still I am not getting any output.
Please can I ask advise
Regards
May be this, check in text box if your vBeginDate and RRTDATE are having date format-
=Sum({$<RRTDATE={"=$(=date(date#(vBeginDate,'YYYY-MM-DD')))"}>}GROSSVAL)
May be this, check in text box if your vBeginDate and RRTDATE are having date format-
=Sum({$<RRTDATE={"=$(=date(date#(vBeginDate,'YYYY-MM-DD')))"}>}GROSSVAL)
It depends on your RRTDATE format also, make sure it matches with the below format
=Sum({$<RRTDATE={"$(=date(date#(vBeginDate,'YYYY-MM-DD')))"}>}GROSSVAL)
Whats the format of your vBeginDate?
in any case, date(date#(vBeginDate,'Format1'),'Format2') - this converts to one format to another.
is any error coimng in the expression,what is the value you store in the vBeginDate.
To debug the problem,i would suggest you to test your rhs in a text object .
date(vBeginDate,'YYYY-MM-DD')
If this is getting you the same date format as your lhs,you should see the result of your expression working.
Thanks for the pointers , the solution worked perfectly
Please close this thread by marking any helpful and a correct answer