Last 12 values dimension limits

[tseebach]

Hi, does anyone know how to get Dimension Limits to show the last 12 values in a chart rather than the first 12. I've tried -12, which gives af nonsense result.

In QV 10 it was possible using the Max Visible Number function under presentation. But In QV11 it does not seem to work.

[#2]

Hi

yes we can do this by using max visible value in qv 10.

I dont know about qv11.

But you can do that using rank function.

try by rank()

may be it will help you.

[CELAMBARASAN]

Hi,

     Did you checked with the dimension limits tab of the chart properties?Under show only drop down-->First,Largest,Smallest options

Celambarasan

[jagan]

Hi,

In QV 11 you can do this by using the settings in Chart Properties -> Dimension Limits tab.  Using First, Largest, Smallest options you can configure as you wish.  Also instead of fixed number you can also suggest the percentage, this is available in Qlikview 11.

Regards,

Jagan

[tseebach]

That is the exact issue, I can only select First, Largest and Smallest. I need something like Last.

[CELAMBARASAN]

Hi,

     Can you tel me the expression of yours?You need to done it with Expression itself like

     Sum({<Customer={"=Rank(-Sum(Sales))<11"}>})

Hope it helps

Celambarasan

[tseebach]

I know I could do that. But that would not work since its a rolling 12 months aggr, summing the first 12 values to the value of first value.

The expression is similar to this but a bit more complex:

rangesum(above(

Sum({$<KPI={"Quality_Plans"},[Rec Type Name]={"Actual"},[Date (FK)]={">=$(=Floor(MonthStart(Max([Date (FK)]),-24))) <=$(=Floor(MonthStart(Max([Date (FK)]),0)))"},[Calender MonthName]= ,[Calender Year]=>} Quantity)

,0,12))

/

rangesum(above(

Sum({$<KPI={"Quality_Plans"},[Rec Type Name]={"Target"},[Date (FK)]={">=$(=Floor(MonthStart(Max([Date (FK)]),-24))) <=$(=Floor(MonthStart(Max([Date (FK)]),0)))"},[Calender MonthName]= ,[Calender Year]=>} Quantity)

,0,12))

[tseebach]

Bump, anyone an idea?

[SunilChauhan]

sort dimension in reverse order  using sort  and

the in presentation

max visible  no 12

hope this help

[tseebach]

Close, but then the timeline goes from right to left, needs to left to right..