topic Re: Limiting graph display with a slider in QlikView

Limiting graph display with a slider

Thu, 25 Jun 2015 07:27:42 GMT

I have a bar graph showing the total value of orders (GoodsTotalEuro) in various groups

I want to limit the value of orders displayed by a slider.

I have the slider controlling a variable (Min_PO) which is set to a value, dependent on where the slider is set.

I have tried to include the Min_PO variable in the expression to limit the display

sum ({$<GoodsTotalEuro > {PO_Min}>}GoodsTotalEuro)

this gives a formula error

and

If(GoodsTotalEuro > {PO_Min, sum(GoodsTotalEuro), 0 )

this displays nothing

Can anyone help please?

amit_saini — Thu, 25 Jun 2015 07:31:15 GMT

Barry,

You can try this:

Thanks,

Thu, 25 Jun 2015 07:44:55 GMT

May be I was not clear.

I don't want to limit the horizontal display, or make it part of a scroll

I only want to display the values in the graph which are above X (PO_Min, variable) controlled by the slider.

So if the slider is set to €10,000, then it will only display PO above this value

thanks

Barry