topic Re: limit the dimention in QlikView

limit the dimension

adiarnon — Wed, 05 Mar 2014 14:08:32 GMT

hi,

i have this table:

call num	handler name	days
1	adi	4
2	shai	23
3	adi	1
4	tal	2

i want a bar chart that in the dimension i will have the call num and in the expression the days.

but i want that only the calls num (dimension) of adi will shown (1,3) .

how can i do that?

Re: limit the dimention

rustyfishbones — Wed, 05 Mar 2014 14:16:20 GMT

Add the Set Analysis in the Expression like below

Re: limit the dimension

rustyfishbones — Wed, 05 Mar 2014 14:19:57 GMT

You can also do this as a calculated dimension like this

but make sure you suppress 0 values like below

Re: limit the dimension

Colin-Albert — Wed, 05 Mar 2014 14:20:44 GMT

Rather than hard-coding the restriction, why not add a list box to allow the user to select the handler name?

Re: limit the dimention

adiarnon — Wed, 05 Mar 2014 14:23:26 GMT

tnx,

but i still see all the call nums in the y axe.

Re: limit the dimention

rustyfishbones — Wed, 05 Mar 2014 14:25:16 GMT

I get this, Is that what you need

Re: limit the dimension

adiarnon — Wed, 05 Mar 2014 14:29:40 GMT

but if i want that even if i am filtering by other handler i will still see the chart with the data of adi calls?

Re: limit the dimension

adiarnon — Wed, 05 Mar 2014 14:30:33 GMT

because i need a chart of each handler....

Re: Re: limit the dimension

rustyfishbones — Wed, 05 Mar 2014 14:34:33 GMT

See attached

Re: limit the dimension

Wed, 05 Mar 2014 14:56:29 GMT

Hi Arnon,

Please try this,

Sum({$<Handler={$(=Handler)}>}Days)

Re: limit the dimension

adiarnon — Wed, 05 Mar 2014 15:12:36 GMT

IN MY CASE THE EXPRESSION ARE MORE complicated and i tried but its not working,,,,

Re: limit the dimension

rustyfishbones — Wed, 05 Mar 2014 15:24:43 GMT

Please share the App so we can help you

Re: limit the dimension

Colin-Albert — Wed, 05 Mar 2014 16:00:33 GMT

You can add handler_name as the first dimension, then use the Trellis option on the Dimensions tab to create a separate chart based on each value in the first dimension.