Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
With the slider you can change it dynamicle.