topic Re: Limit values from a graph in QlikView

Limit values from a graph

Thu, 05 Nov 2015 21:05:38 GMT

I have a graph and i wanna limit the values to the top 5 or top 7 or the 'x' value that i wanna see

i did an inline table like this

VALOR_LIMITE:

LOAD * INLINE [

VALOR_LIMITE,

12,

];

and in the dimension limits i use this field, but it isn´t working

what do you suggest?

Regards

Re: Limit values from a graph

Thu, 05 Nov 2015 21:38:00 GMT

Jeremias,

Correct me if i'm wrong, as your field have multiple values which value are you passing to dimension limits to limit ?

use a variable, on selection of value pass the selected value into variable & use that variable in dimension limits, by using variable u can choose an option to feed it data from input fields too.

Hope this helps.

thanks

Brad.

Re: Limit values from a graph

Anonymous — Fri, 06 Nov 2015 02:04:38 GMT

Open a new script and enter:

DummyData:

Load

RowNo() as SalesKey,

RowNo() * 3 as OrderAmount

AutoGenerate(50);

VALOR_LIMITE:

LOAD * INLINE [

VALOR_LIMITE,

12,

];

1. Make a bar chart with SalesKey as the dimension and sum (OrderAmount) as the expression.

2. Add a Slider/Calendar Object. Set the Input Style to Slider, make sure Field is selected under Data, and select VALOR_LIMITE to its right. Make sure Discrete is checked in the Value Mode section.

3. Open up the properties for the new chart and go to the Dimension Limits tab. Make sure SalesKey is selected on the right, check "Restrict which values are displayed using the first expression," then select Show only. Select Largest, and then in the box to its right enter "=GetFieldSelections(VALOR_LIMITE)".

The slider now controls the number of values included in the chart. Note the 8 bars in the image below. The slider is restricted to the values entered in the script.

Re: Limit values from a graph

settu_periasamy — Fri, 06 Nov 2015 02:17:11 GMT

Hi,

Do you want the Graph based on your Selection in the VALOR_LIMITE? Like this..

try to put the below expression in your Dimension limit..

=if(isnull(GetFieldSelections(VALOR_LIMITE)),Count(Dim),GetFieldSelections(VALOR_LIMITE))

Re: Limit values from a graph

Anonymous — Fri, 06 Nov 2015 03:34:09 GMT

To prevent a user from selecting more than one value in the VALOR_LIMITE list box, select one value and then open the List Box properties. In the General tab check Always one selected value.

You may want to set a trigger on open to select a default value since reloads will sometimes deselect all options.

Re: Limit values from a graph

sasikanth — Fri, 06 Nov 2015 05:57:41 GMT

hi,

Instead its very easy to use a variable with input box ,

1)Create a Variable vLimit and assign a values 0

2) Take one input box and add this variable to it

3) Open Chart --> properties --> Dimension Limits --> select largest --> erase default values use this variable $(vLimit)

and Un check others

4) Give the value in input box then Chart display will change according to your selections

Re: Limit values from a graph

jagan — Fri, 06 Nov 2015 06:11:38 GMT

Hi,

Try like this in Dimension Limits

Chart Propeties -> Dimension Limits -> Select Show Only -> Largest 5 Values.

Hope this helps you.

Regards,

Jagan.

Re: Limit values from a graph

Fri, 06 Nov 2015 13:20:42 GMT

Hey

Thanks for the example

Can i use a ciclic dimension ?

Re: Limit values from a graph

Fri, 06 Nov 2015 13:22:31 GMT

Hey

Thank you for your answer

Can i use a cyclic dimension with this?

I tried using "" and '' but i couldn´t make it work

Regards

Re: Limit values from a graph

settu_periasamy — Fri, 06 Nov 2015 13:35:07 GMT

You can use it. You need to use Getcurrentfield (Your group name )

Re: Limit values from a graph

Anonymous — Fri, 06 Nov 2015 13:41:10 GMT

You can try Jagan's suggestion

Else

Create a variable and take it in input box

and set it into Presentation tab under when ITem exceed scroll bar...Top right midle..

PFA..

their are two values of dimension only..

Re: Limit values from a graph

Anonymous — Fri, 06 Nov 2015 23:18:36 GMT

Sorry, should have specified to leave out the quotes. Put everything between the quotes into the field.

You can use in conjunction with a cyclic group. Make sure that you cyclic group replaces the existing dimension in the dimension tab and in the dimension limits tab.

Re: Limit values from a graph

Wed, 11 Nov 2015 17:41:20 GMT

Hi!

thank you for the help

But i realized i need one more thing

In the dimmensions i have another dimension: Month Year so i'm seeing the top 5 of each month.

How can i see the top 5 or 10 or whatever for all the months?

Regards

Re: Limit values from a graph

Wed, 11 Nov 2015 17:51:58 GMT

Hi!

thank you for the help

But i realized i need one more thing

In the dimmensions i have another dimension: Month Year so i'm seeing the top 5 of each month.

How can i see the top 5 or 10 or whatever for all the months?

Regards

Re: Limit values from a graph

jagan — Thu, 12 Nov 2015 06:08:06 GMT

Hi,

Atttach some sample file so that it would be easier to understand.

Regards,

jagan.

Re: Limit values from a graph

Anonymous — Thu, 12 Nov 2015 06:16:26 GMT

if you have similar kind of dimension like you said, Year & Month..

then make a Drill group of these dimension, it will work into same way

Re: Limit values from a graph

Thu, 12 Nov 2015 14:08:24 GMT

Hey!

I need a graph like this

now i'm using a top 5. But how i said it isn't working

Thank you

Re: Limit values from a graph

Thu, 12 Nov 2015 14:09:11 GMT

Hey. It's not easy to attach the qvw right now. But this is the graphic.

now i'm using a top 5. But how i said it isn't working because i see the top 5 of each year month or something like that. I´m not sure but i suppose that

Thank you

Re: Limit values from a graph

Thu, 12 Nov 2015 14:11:34 GMT

Hi!

thank you for the help

But i realized i need one more thing

In the dimmensions i have another dimension: Month Year so i'm seeing the top 5 of each month.

How can i see the top 5 or 10 or whatever for all the months?

Its this graphic

Regards

Re: Limit values from a graph

sasikanth — Thu, 12 Nov 2015 14:28:34 GMT

Hi,

Please see the attachment