Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Set Analysis to get Previous Quarter, Half and Year sales

Hi All,

Could you please help me to get previous Quarter, Half and Year sales.

If user select FY18 Q1, user should get FY17 Q1 sales.

If user select FY18 H1, user should get FY17 H1 sales.

If user select FY18, user should get FY17 sales.

I am attaching the sample data for your reference.



1 Reply

You need some sort of master calendar to more easily do this type of analyis. I suggest that you upload a small sample QVW file and then you can get more specific help. The set analysis will depend on the fields and how you are selecting the date ranges above.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein