topic Date Format within Set Analysis in QlikView

Date Format within Set Analysis

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

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

Digvijay_Singh — Fri, 16 Mar 2018 20:46:24 GMT

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)

shiveshsingh — Sat, 17 Mar 2018 02:50:07 GMT

It depends on your RRTDATE format also, make sure it matches with the below format

=Sum({$<RRTDATE={"$(=date(date#(vBeginDate,'YYYY-MM-DD')))"}>}GROSSVAL)

Qrishna — Sat, 17 Mar 2018 02:52:05 GMT

Whats the format of your vBeginDate?

in any case, date(date#(vBeginDate,'Format1'),'Format2') - this converts to one format to another.

tripatirao — Sat, 17 Mar 2018 06:13:14 GMT

is any error coimng in the expression,what is the value you store in the vBeginDate.

sasiparupudi1 — Sun, 18 Mar 2018 20:04:03 GMT

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.

georgegv — Thu, 22 Mar 2018 06:38:22 GMT

Thanks for the pointers , the solution worked perfectly

sasiparupudi1 — Thu, 22 Mar 2018 06:40:34 GMT

Please close this thread by marking any helpful and a correct answer