Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Date Format within Set Analysis

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

1 Solution

Accepted Solutions
Highlighted
Master III
Master III

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)

View solution in original post

7 Replies
Highlighted
Master III
Master III

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)

View solution in original post

Highlighted
Master
Master

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

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

Highlighted
Specialist III
Specialist III

Whats the format of your  vBeginDate?


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

Highlighted
Creator II
Creator II

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

Highlighted
Master III
Master III

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.



Highlighted
Contributor II
Contributor II

Thanks for the pointers , the solution worked perfectly

Highlighted
Master III
Master III

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