topic Re: Anomalies in QlikView

Anomalies

Tue, 12 Jun 2012 13:55:52 GMT

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!

Re: Anomalies

Miguel_Angel_Baeyens — Tue, 12 Jun 2012 14:08:08 GMT

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

Re: Anomalies

Tue, 12 Jun 2012 14:39:33 GMT

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

Miguel_Angel_Baeyens — Tue, 12 Jun 2012 15:14:29 GMT

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