Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
JustinDallas
Specialist II
Specialist II

Date={"<=$(=today()-1)" fails, Date={"<=$(=today())" works

Hello Everyone,

So I've got a Set Analysis that seems to have randomly broken yesterday.  I am trying to say "any date in the past, not including today".  For that, I have

Date={"<=$(=today()-1)"

The SetAnalysis containing this gives me the infamous Dash of Doom "-" when put into a Text Object.  However, if I remove the "-1" and just have ,Date={"<=$(=today())", it works like a charm.  What is going on here?   I got my how to manipulate a date information from this response in this post by Arya v

subtract 120 days from date

Any help is greatly appreciated.

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

Try it with: Date={"<=$(=date(today()-1, 'YourFormat'))"}


- Marcus
 

View solution in original post

4 Replies
Miguel_Angel_Baeyens

Justin,

Try

Date = {'$(=Date(Today()-1))'}

Miguel

marcus_sommer
MVP & Luminary
MVP & Luminary

Try it with: Date={"<=$(=date(today()-1, 'YourFormat'))"}


- Marcus
 

View solution in original post

patroser
Partner
Partner

Hi,

you could also try this one, built with set analysis wizard

=Sum( {$<Date={"<$(=Today())"}>} Value)

Best regards,

Patrick

Edited: had an error in it, corrected it

JustinDallas
Specialist II
Specialist II
Author

Thanks.  I'm still upset that it worked up till recently, and then it decided to kick the bucket.