Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
VishalSingh18
Contributor III
Contributor III

Dates, set analysis not sure what to do

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

1 Solution

Accepted Solutions
Brett_Bleess
Employee
Employee

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

2 Replies
VishalSingh18
Contributor III
Contributor III
Author

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
Employee
Employee

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.