Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help in data display between a range of Quarters

Hello All,  I am trying to create a table to display values between specified Quarter's only. For instance , If i select Q1-2013 , the table should display seperate columns from Q1-2012 to Q1-2013 (last 5 quarters values) .  Can somebody help me out here ??

3 Replies
Not applicable
Author

Hi Ravi,

You can achieve it by defining a couple of variables and using set analysis in your expressions.

In attached .qvw file I have done it for last 2 quarters but if you want you can continue in same way.

I hope it will help you.

Best Regards

Ersan Alkan

Not applicable
Author

Thanks Ersan ... that was helpful

jagan
Luminary Alumni
Luminary Alumni

Hi Ravi,

Try this expression

=Sum(<YearDimension=, MonthDimension=, QuarterDimension=, WeekDimension=,

DateDimensionName={'>=$(=QuarterStart(Max(DateDimension), -4))<=$(=Date(Max(Date)))}>} MeasureName)

Replace YearDimension, MonthDimension, QuarterDimension, WeekDimension, DateDimensionName with your corresponding field names if any.

Hope this helps you.

Regards,

Jagan.