topic slider problem in QlikView

slider problem

Mon, 24 Jan 2011 11:46:58 GMT

hi ,

i want to know how will i use slider with my chart to find out (top n providers by revenue)

in my chart i am using provider description is a dimension and sum(revenue) is an expression.

in my slider i am using min value 5 max value 30 and static step=5.

please let me know the steps

slider problem

Mon, 24 Jan 2011 12:14:13 GMT

you have to set the variable to 0

use it in the slider as you like

Than in the chart options -----> Presentation -----> Max Number and in it put your variable name

slider problem

Anonymous — Mon, 24 Jan 2011 12:14:56 GMT

If I understand you corretly, you want to show a top N in your charts and you want to be able to set the N with a slide, am I right?

I do this by making a variabel (vTopN) and add this variable to a slide.

Then go to the presentation tab of the charts which you want to show the top N.
Check Max Number (1-100) box and give the name of the variable (vTopN) as the expression.

slider problem

Mon, 24 Jan 2011 12:16:55 GMT

ya u r right.i want to show top n provider in respect of revenue in my chart

slider problem

lironbaram — Mon, 24 Jan 2011 12:17:53 GMT

hei

attach is an example

the steps you need to do:

1. build a chart with:

dim :provider

exp: sum(revenue)

2.create a varaible with the name Slider.

3.go to presntion tab in the chart properties

and in the box in the top left side Max Visible number enter the formula "=Slider"

thats it

hope its help you

slider problem

gauravkhare — Mon, 24 Jan 2011 12:19:36 GMT

hi.........

Dennis is right. Declare a variable and use it in your slider. also set the limit to 5...and sort order to decreasing.

slider problem

Mon, 24 Jan 2011 12:30:01 GMT

hi it is working fine thanks

slider problem

Mon, 24 Jan 2011 12:36:44 GMT

You have to define a variable with a value. Ex: Va = 5 (define in Variable Overview).

This variable should be added in Slider as well the Chart/Graph that you are working on.

In Slider go to General -> Select Variable and select the variable name from the list box.

Similarly set the values min as 5 , max as 30 and static step as 5.

Go to chart -> Presentation -> enable the check box (max visible number (1-100) and enter the variable name as =va1).

Now what ever you select in slider the same will reflect in the above chart.