Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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?

4 Replies
Not applicable
Author

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)

Not applicable
Author

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.

Not applicable
Author

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

Not applicable
Author

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