topic Re: Dynamic Dimension in QlikView

Dynamic Dimension

Thu, 05 Dec 2013 18:04:28 GMT

Hi,

I want to create Bar chart to show number of clients by Revenue?

Client	Revenue
C1	1000
C2	2000
C3	3000
C4	2000
C5	5000
C6	8000
C7	12000
C8	3000
C9	1000
C10	2500

I want the X axis (dimension) to be bucketed say 0-1K , 1-2K, 2-5K, 5-10K, >10K

How can I group the data to display the count of clients that falls with the dimension? The dimension could be dynamic (probably driven by slider)?

how can we make the dimension dynamic. Like user controls using a slider or so based on the Revenue amount. Basically I want the user to define the buckets on the fly. Any Ideas please ?

Appreciate your help

Thank you

Re: Dynamic Dimension

Anonymous — Thu, 05 Dec 2013 19:32:36 GMT

Not sure that the slider is the best way - try the attached...

Re: Dynamic Dimension

fred_s — Thu, 05 Dec 2013 19:57:37 GMT

Hi Dimple,

See attachment..

Re: Dynamic Dimension

fred_s — Thu, 05 Dec 2013 20:12:26 GMT

Sorry Dimple,

In this case it's probably better to use the formula in your Charts Dimension,
See attachment

Re: Dynamic Dimension

Thu, 05 Dec 2013 20:20:21 GMT

Hello Mike Thanks for you reply

This is close to what I was expecting. Can we use a single slider to control the min max range of several buckets ?

Re: Dynamic Dimension

Thu, 05 Dec 2013 20:21:27 GMT

Thanks Fred

Great Idea but we really wanted the user to control the range. It could be anything we dont want to prefix

Re: Dynamic Dimension

Anonymous — Thu, 05 Dec 2013 20:43:31 GMT

Single slider gives you one value of a variable. If you are OK with calculating the borders of all five buckets based on it, you can use single variable. Say, you set a variable to 1K, and calculate borders as Variable*2, *5, and *10. In this case the borders are not independent, changing variable changes all bucket borders.

Five buckets - you need four or five variables to set the borders.

Or maybe I'm missing something(?)

Regards,

Michael

PS: from the presentation point of view, I'd rather use input box than sliders. Don't like sliders...

Re: Re: Dynamic Dimension

Thu, 05 Dec 2013 21:10:20 GMT

Hello Dimple,

I have modified fred's solution.

Create a variable "BucketRange". You can add one more variable for different bucket size in the dimension. Check Class functions syntex.

Dimension :

=class(Revenue,$(BucketRange),'Revenue')

Expression:

=count(Client)

Hope this is what you are looking for.

Re: Dynamic Dimension

Fri, 06 Dec 2013 14:19:01 GMT

I understand slider may not be the good choice but it is preferred one.

Great if you could provide an example dynamic calculation of borders by variable

Re: Re: Dynamic Dimension

Anonymous — Fri, 06 Dec 2013 14:43:24 GMT

As I've mentioned above. You have a slider only for the variable b1 (upper border of the lowest bucket. Define the variables for the other upper borders like this, for example:

b2 = b1*2

b3 = b1*5

b4 = b1*10

Actually it is not necessary to have multiple variables in this case - just use all this "*n" directly in the expressions. See attached.

(But it is a deviation from your original request - you cannot control buckets independently with one variable)

Re: Dynamic Dimension

Fri, 06 Dec 2013 15:31:52 GMT

Thanks Michael. As we concluded that we can not achieve using single slider. This is better a better approach

Appreciate your help