Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
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.
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
That expression gives me the "error in set modifier expression" message.