topic Re: Date range in set expression in QlikView

Date range in set expression

yoganantha321 — Sat, 16 Nov 2024 04:38:28 GMT

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

Re: Date range in set expression

sunny_talwar — Mon, 28 Jan 2019 14:41:15 GMT

Try using these expressions

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

and

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

Re: Date range in set expression

yoganantha321 — Tue, 29 Jan 2019 04:51:46 GMT

Thanks Sunny.