Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Help in data display between a range of Quarters

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

Re: Help in data display between a range of Quarters

Thanks Ersan ... that was helpful

MVP
MVP

Re: Help in data display between a range of Quarters

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.

Community Browser