4 Replies Latest reply: Jul 18, 2016 9:16 AM by Kyle Dechy

# Exclude Data From 1 Date

While putting a line chart together my Y-Axis range is bigger than necessary due to a spike that occurs on one day.  Is there a way I can omit that date in my measure?

• ###### Re: Exclude Data From 1 Date

You can use set analysis to exclude that date. It's like using a where clause in SQL.

I found this video tutorial really helpful:

Beginners' Introduction to Set Analysis - Qlik Sense and QlikView - YouTube

I think your measure would look similar to :

sum({\$<Date-={"2016-7-6"}>}Sales)

• ###### Re: Exclude Data From 1 Date

I watched the video and it clarify some things, but I still can't get my expression correct... I tried

Sum({1-\$<Cur Day={05-30-2016}>}[Causal Total Time])

I'm summing the "causal total time" for my time period dimension which is "cur day", but I want to omit the data for 5-30-2016.

• ###### Re: Exclude Data From 1 Date

I'm glad that to see that you're headed in the right direction!

I would try using the following expression in your measure:

Sum({\$<Cur Day-={"05-30-2016"}>}[Causal Total Time])

There is a second video which teaches you more about set analysis, hope that can clarify things.

Set Analysis - Part 2 - Cool Stuff You can Do: Qlik Sense and QlikView - YouTube

• ###### Re: Exclude Data From 1 Date

That expression gives me the "error in set modifier expression" message.