topic Button select a number of values in QlikView

Button select a number of values

pietapa — Thu, 05 Jan 2023 11:29:00 GMT

Hi,
I am trying to do a button, which can exclude a bunch of values. Is there a way that I can exclude all values after a certain point?
For example I have a chart which show me the revenue from 1.2015 to 12.2022. Since I want to have a before and after covid visualization, the graph should show the revenue the time before covid after clicking the "PRE"-Button and otherwise.

I am not so fit with the syntax of the QlikView.....
Thank you for help.

Re: Button select a number of values

pietapa — Thu, 05 Jan 2023 11:42:20 GMT

Thank you for your response.
But can you explain me what this expression do and where I have to write it down?

Re: Button select a number of values

Bill_Britt — Thu, 05 Jan 2023 11:55:45 GMT

Hi,

The best bet is to create a variable that has the information in it, then you the button to change the variable values.