Date Format within Set Analysis

[georgegv]

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 · Accepted solution]

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]

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

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

[krishna_2644]

Whats the format of your  vBeginDate?

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

[tripatirao]

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

[sasiparupudi1]

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]

Thanks for the pointers , the solution worked perfectly

[sasiparupudi1]

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