Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Remove 1 Date From Range

I am trying to remove one date from a range I have in a line graph... The expression I'm trying to use is:

Sum({$<CurDay -={"5/30/2016"}>}[Causal Total Time])

I cannot get the chart to omit 5/30/2016.... Any Ideas?

24 Replies
sunny_talwar

Is CurDay a date field? You need to make sure that formatting on the RHS of the expression matches the one on the LHS. Also look here for date in set analysis

Dates in Set Analysis

Not applicable
Author

Yes, "CurDay" is my date field measure... I have a set of data going across a time period, it spiked on one day so I just want to omit it from my chart. What do you mean by "RHS" & "LHS"??

sunny_talwar

Check below:


Sum({$<CurDay -={"5/30/2016"}>}[Causal Total Time])


LHS format needs to be the same as RHS

May be try something like this:

Sum({$<CurDay -={"$(=Date(MakeDate(2016, 5, 30), 'DateFieldFormatHere')"}>}[Causal Total Time])

Not applicable
Author

Didn't work.

spring101
Contributor III
Contributor III

Just out of curiosity are there any other expressions in this chart? Also, what is the data type of [Causal Total Time]? Finally, just for the heck of it, would you try the following:

Instead of:  -={"5/30/2016"}


perhaps try: ={'*'}-{"5/30/2016"}

Not applicable
Author

No other expressions, the causal total time is in minutes.. just tried this:

Sum({$<[CurDay]={'*'}-{"5/30/2016"}>}[Causal Total Time])

Didn't work.

sunny_talwar

It doesn't really help knowing that it didn't work? May be provide what issue you ran into? Expression showed error, 0, null? Can you provide a sample to look at?

Jose_Del_Rio
Employee
Employee

Here you have 3 different ways to do what you are asking for. I hope you find this information helpful!

... see the attach QVW file...

Not applicable
Author

OmitDate.jpg

Your qvw. file will not open for me.... Here is an image of my line graph. There are 2 dimensions in this chart... Cur Day (MM-DD-YYYY) & Crew Name (A,B,C,).... The measure is Causal Total Time (Minutes)...

You see the spike for May 30? I just want that omitted from the chart. I've watched multiple videos on set analysis, tried everything I can.. Any expression ideas please post in reply to this. Below is what I am trying now, it gives me the "OK" but does not omit the date.

Sum({$<CurDay -={"$(=CurDay(5,30,2016), 'MM-DD-YYYY')"}>}[Causal Total Time])