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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
pkelly
Specialist
Specialist

Set Analysis with Variables

Hi all,

=Sum({<soi_RevisionDate ={"$(=varToday)"}, soi_HistoricalMonthNumber_Latest = {0}, soi_LatestDate = {"$(=varTomorrow)"}>} soi_Sales)

I have the above Set Analysis statement which I am using in a Pivot Table.

soi_RevisionDate is the day the orders was keyed

soi_HistoricalMonthNumber_Latest is the month in which the order is due with 0 = current month

soi_LatestDate is the latest date the order is due to the customer

varToday = todays date

varTomorrow = tomorrows date

What I am trying to do is show orders keyed today which are due this month but greater than tomorrow

The statement I have show will only give orders keyed today which are due tomorrow - how do I make this greater than tomorrow?

Thanks in advance for any assistance given.

Paul

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

The syntax should be like

{< soi_LatestDate = {">=$(varTomorrow)"} >}

Or even if you need to expand further

{< soi_LatestDate = {">=$(=varTomorrow)"} >}

View solution in original post

2 Replies
Miguel_Angel_Baeyens

The syntax should be like

{< soi_LatestDate = {">=$(varTomorrow)"} >}

Or even if you need to expand further

{< soi_LatestDate = {">=$(=varTomorrow)"} >}

pkelly
Specialist
Specialist
Author

Thanks Miguel...ended up with the following

soi_LatestDate = {">$(=varTomorrow)"}