Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
yoganantha321
Contributor II

Date range in set expression

Hi all,

I have a column called month_date with list of dates which report should be generated and another column called report date which contains the date on which the reports are generated.

My expected output:

If i select a particular Report_Dates, the month_date less than the report_dates must be viewed in the bar chart.

Output I am getting:

Now, If i select  a particular date that particular date's bar is showing.

 

Anybody can help in this!!!!!

Regards,

Yoganantha Prakash G P  

Labels (2)
1 Solution

Accepted Solutions

Re: Date range in set expression

Try using these expressions

Only({<Report_Dates = {"<=$(=Max(Report_Dates))"}>}[Assessment Goal Curve])

and

Only({<Report_Dates = {"<=$(=Max(Report_Dates))"}>}Total_Compliance)

image.png

2 Replies

Re: Date range in set expression

Try using these expressions

Only({<Report_Dates = {"<=$(=Max(Report_Dates))"}>}[Assessment Goal Curve])

and

Only({<Report_Dates = {"<=$(=Max(Report_Dates))"}>}Total_Compliance)

image.png

yoganantha321
Contributor II

Re: Date range in set expression

Thanks Sunny.