Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Anomalies

Hi,

Does anybody know how I can view a chart of data, removing some anomalies that I dont want to display at the same time?? e.g. for a barchart I want to see the temperature on everyday of the month except for tues 22nd may because it was exceptionally high etc.

Thanks!

Tags (1)
1 Solution

Accepted Solutions

Re: Anomalies

Hi David,

There are some ways but I would say that the faster for the user is to create a listbox with the Date, select 22nd, right click on the listbox, then click on "Select Excluded".

Hope that helps.

Miguel

3 Replies

Re: Anomalies

Hi David,

There are some ways but I would say that the faster for the user is to create a listbox with the Date, select 22nd, right click on the listbox, then click on "Select Excluded".

Hope that helps.

Miguel

Not applicable

Re: Anomalies

Hi Miguel,

Thanks, just what I needed!

Once I have excluded the anomalies from my e.g. bar chart, Do you know is there any way to dynamically set the y-axis so that all the other data fills the screen

Regards,

David C

Re: Anomalies

Hi David,

Sorry I don't get the second part: fill the screen. I mean, if you exclude those values from the listbox, the chart will show only those values that are excluded, won't they?

Or is that you want to show those values somewhere else in the sheet?

Hope that helps.

Miguel

Community Browser