topic Re: Dimension limits in QlikView

Dimension limits

Mon, 18 Jan 2016 06:46:13 GMT

Hi;

I have a bar graph. My dimension is week number and my expression is avg(LoadingDuration). I now want my bar graph to only show avg(LoadingDuration) for past 3 weeks only and not to show avg(LoadingDuration) for all the week.

How do l limit my dimensions to past 3 weeks average loading durations?

Regards;

Moses

Re: Dimension limits

dinuwanbr — Mon, 18 Jan 2016 08:52:57 GMT

Hi,

you can use Dimension Limits to limit the dimension.

BR,

Dinu1

Re: Dimension limits

Mon, 18 Jan 2016 10:03:17 GMT

How do l use dimension limits to limit the dimension to only show the last 3 weeks data?

Re: Dimension limits

Mon, 18 Jan 2016 10:13:57 GMT

you can add calculated dimension for eg..

if(weekstart(Today(1))-weekno<21,weekno)

where weekno is your dimension

Re: Dimension limits

Mon, 18 Jan 2016 10:26:58 GMT

Hi, maybe you can try this:

First go to dimension limits tab and check the box which restricts the values and select First 3.

Go to Sort tab: Select State descending and Numeric value descending.

Suppose we are in the tenth week, you will get values 10 9 and 8 on your x axis.

Regards,

Pratik

Re: Dimension limits

HirisH_V7 — Mon, 18 Jan 2016 10:43:35 GMT

Hi,

You can use expression like this,

Last 3 Weeks:

Avg({<Date={‘>=$(=WeekStart(Today(), -2))<=$(=Today())’}>} Loading Duration )

Hope this helps ,

Hirish