topic Re: dimension limits display last 6 months in QlikView

dimension limits display last 6 months

Wed, 21 May 2014 02:22:28 GMT

Hi, in line chart, how do I display data for only the last 6 months? Cause' dimension limits only have the option of displaying first,largest and smallest values. Thanks.

Re: dimension limits display last 6 months

Wed, 21 May 2014 02:33:45 GMT

Sum({$ < Year = {">=$(Year(Today())-5)"}>} Sales)

Re: dimension limits display last 6 months

Wed, 21 May 2014 02:35:07 GMT

if it is just a simple dimension, then create a calculated dimension as follows:

if (Year >= Year(today())-5, Year)

Then check "Suppress when null"

Thanks,

Ram

Re: dimension limits display last 6 months

jagan — Wed, 21 May 2014 02:43:23 GMT

Hi Rachel,

Try this expression

=Sum({< YearDimensionName=, QuarterDimensionName=, MonthDimensionName =, DateDimensionName= {'>=$(=MonthStart(Max(DateDimensionName), -5))<=$(=Date(Max(DateDimensionName)))'}>} MeasureName)

Replace YearDimensionName, QuarterDimensionName, MonthDimensionName, DateDimensionName and MeasureName with your actual fields.

Hope this helps you.

Regards,

Jagan.

Re: dimension limits display last 6 months

Fri, 06 Feb 2015 09:44:53 GMT

Hi Jagan,

How can I do this in dimenssion level.

Regards

Anup

Re: dimension limits display last 6 months

Anonymous — Fri, 06 Feb 2015 10:17:40 GMT

Hi,

Try

In UI:

=Sum({<YearMonth=, Num(Date#(YearMonth,'YYYYMM')) = {">=$(=Num(AddMonths(Max(Date#(YearMonth,'YYYYMM')),-5)))<=$(=Num(AddMonths(Max(Date#(YearMonth,'YYYYMM')),0)))"}>} MeasureName)

Inscript:

LOAD *,

if(Date >= AddMonths(MonthStart(today()), -5) and Date <= monthstart(today()), 1, 0) as Flag6Month

RESIDENT Table;

And use flag as required

Regards

Neetha