Solved: Re: Dates, set analysis not sure what to do - Qlik Community

VishalSingh18 · ‎2020-02-27

Hello,

I have attached a excel in the attachment and i have to visualize RPP Planned and RPP actual is a straight/pivot table with location as dimension and what i need is a expression that give Actual RPP for a specified date(dates in the sheet are week end dates i.e Saturday) for which Actual RPP is not null the highest date till RPP actual is present is till 15-Feb while planned RPP is calculated for entire year

Regards

Vishal Singh

Brett_Bleess · ‎2020-03-31

Have a look at the following Design Blog post, should be of some help to you:

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

VishalSingh18 · ‎2020-02-27

what i need is RPP for previous week with respect to week where data is present and so on till 4th prior week

Brett_Bleess · ‎2020-03-31

Have a look at the following Design Blog post, should be of some help to you:

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.