Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.