topic Re: Slider not affecting chart in QlikView

Slider not affecting chart

Tue, 20 Aug 2013 07:03:45 GMT

Hi Community experts,

Have some query.

I have used variable at back end to get

top N customers,

Other customers and

Total of Top N customers. I want to make it dynamic.

I dont want to use dimention limits and rank or aggr functions as they are causing performance issues . I want to do it at script side. Now issue is to make this variable as dynamic. Variable wil change in front end but not affecting at back end.

Please help me . attached qvw.

Re: Slider not affecting chart

jjordaan — Tue, 20 Aug 2013 07:38:14 GMT

Hi Suneela,

If you create a variable in the script (backend) it will not change if you change the value in the frond end.

Consider the value created in backed end as a starting point.

Every time when you reload the script the value of the variable will be the same as the script.

When you go to the properties of the object and to the tab presentation you can place the variable $(vCustomer) in the Max Number (1 - 100) checkbox.

I hope this helps

Re: Re: Slider not affecting chart

Tue, 20 Aug 2013 08:05:44 GMT

Hi,

That is fine. But how can I make it as it dynamically change the chart. If I use the variable at presentation label then it will show at max 5 only.

Is there any alternative to make it at front end without using rank,aggr or dimention limits.

Re: Re: Slider not affecting chart

jjordaan — Tue, 20 Aug 2013 10:07:15 GMT

With the slider you can change it dynamicle.