topic Re: scroll bar limit in QlikView

scroll bar limit

Wed, 13 May 2015 07:51:35 GMT

Hi,

I've got a scroll bar with date values ('MM-YYYY'). The data is showing the all values in that field. I'd like to limit the shown months. So let's say I'd like to have all values of the 12 months (=last 12 values).

Can anybody help me? With bar Charts it's easy to get the last 12 values, but what about scroll bars?

Cheers,

Tobi

Re: scroll bar limit

buzzy996 — Wed, 13 May 2015 08:04:30 GMT

try this way,by using expression u can get last 12 values and we can also control if u need some thing from scroll bar..see below.

Re: scroll bar limit

Wed, 13 May 2015 08:10:04 GMT

Thanks, but that's not what I'm looking for.

With scroll bar I mean something like that:

Re: scroll bar limit

buzzy996 — Wed, 13 May 2015 08:21:28 GMT

ok,can u try with the same expression as u said above u can diaply last 12 values in bar chart,use the same expression in slider object--general tab-Data-Field-select expression "place the same expression here."

Re: scroll bar limit

rubenmarin — Wed, 13 May 2015 08:28:28 GMT

Hi Tobias, that's a slider, in it's properties, in the field list, the last option is <expression>, select that option and use an expression that filters the values you want to show, ie:

=Aggr(If(DateField>AddMonths(Max(TOTAL {1} DateField), -12), DateField), DateField)

Re: scroll bar limit

Wed, 13 May 2015 08:54:09 GMT

Thanks Ruben,

jep that's been what I'm looking for

But the expression is not the right one.. Any other suggestions?

Re: scroll bar limit

buzzy996 — Wed, 13 May 2015 09:27:07 GMT

can u share ur .qvw?

Re: scroll bar limit

rubenmarin — Wed, 13 May 2015 09:27:57 GMT

Hi Tobias, you're right that doesn't works when you select a date, I didn't tested, try with a simpler:

=If(OrderDate>AddMonths(Max(TOTAL {1} OrderDate), -12), OrderDate)

Re: scroll bar limit

Wed, 13 May 2015 09:36:42 GMT

Great, thanks Ruben.. Exactly what I looked for!