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: 
Not applicable

set analysis: use date functions and variables

Hi,

I would like to use set analysis to speed up my application in stead of if statements.

count({< type={'CA','CC'} >} if(InMonth(ass_start_date,vReportingDate,0),assessmentId))

How can i insert this if inside the set analysis? (only show  the records where the month of the start start is in the month of our reporting date). The reporting date is inside my variable.

Thank you very much!

1 Solution

Accepted Solutions
stigchel
Partner - Master
Partner - Master

Hi,

You can probably load a field with the month of ass_start_date and then compare that field in the set analysis to the month of vReportingDate. You will need dollar sign expansion for the variable and function.

Example of dollar sign expansion for always reporting the last date:

{<Date={'$(=Max(Date))'}>}

View solution in original post

1 Reply
stigchel
Partner - Master
Partner - Master

Hi,

You can probably load a field with the month of ass_start_date and then compare that field in the set analysis to the month of vReportingDate. You will need dollar sign expansion for the variable and function.

Example of dollar sign expansion for always reporting the last date:

{<Date={'$(=Max(Date))'}>}