Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Count of a field based on a date plus number of days.

Hi there,

i would like to create  a set analysis of count of a field "refid" for when the date field "REQDATEORDER" is smaller than today +7 days in the fufure.

If today is the 1st of May the set analyisis should give all records with the "REQDATEORDER" before the 8th of May.


Thanks in advance for your help.

Lawrence

1 Solution

Accepted Solutions
sunny_talwar

May be like this

{<REQDATEORDER = {"$(='<=' & Date(Today() + 7, 'DateFieldFormatHere'))"}>}

View solution in original post

4 Replies
sunny_talwar

May be like this

{<REQDATEORDER = {"$(='<=' & Date(Today() + 7, 'DateFieldFormatHere'))"}>}

Anonymous
Not applicable
Author

Woao that was fast, thank you very much Sunny.

Anonymous
Not applicable
Author

Hi again,

is there any good way to understand the syntax of the script? I really can not understand the logic behind it.

Thanks,

Lawrence

sunny_talwar

best place to start would be here

A Primer on Set Analysis

and then go here for advanced stuff

Set Analysis: syntaxes, examples