Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lavrendis
New Contributor

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
MVP
MVP

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

May be like this

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

4 Replies
MVP
MVP

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

May be like this

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

lavrendis
New Contributor

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

Woao that was fast, thank you very much Sunny.

lavrendis
New Contributor

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

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

MVP
MVP

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

best place to start would be here

A Primer on Set Analysis

and then go here for advanced stuff

Set Analysis: syntaxes, examples