Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Set Analysis: Date Range + 1 more date

Hi All,

I need to create a set analysis which will output dates:

example:

If I select the Month (October)

I will output the last day of the month as of today, then i will output the dates for last month which fall on sundays

Date

Oct 1

Sep 7

Sep 14

Sep 21

Sep 28

I can already output the range from Sep 7~Sep28. Concat({<date={">=StartDate<=Prevmonthlastdate"}, DayName={'Sun'}>}Date)

How can I incldue Oct1 in the selection in my set analysis?

Tags (1)
1 Reply
MVP & Luminary
MVP & Luminary

Re: Set Analysis: Date Range + 1 more date

Concat({<Date={">=StartDate<=Prevmonthlastdate","Oct 1"}, DayName={'Sun'}>}Date)


talk is cheap, supply exceeds demand