topic Re: Help in data display between a range of Quarters in QlikView

Help in data display between a range of Quarters

Tue, 21 Jan 2014 11:20:52 GMT

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

Re: Help in data display between a range of Quarters

Tue, 21 Jan 2014 17:20:33 GMT

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

Re: Help in data display between a range of Quarters

Wed, 22 Jan 2014 06:58:02 GMT

Thanks Ersan ... that was helpful

Re: Help in data display between a range of Quarters

jagan — Wed, 22 Jan 2014 07:12:50 GMT

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.