Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vinod2086
Contributor II

Set Expression Issue

Hi,

Can any one help me to write set expression based on the following.

                -  Level = critical

                - Submission date - report run date > 7.0 days

                - Status not equal to closed

                - Intermediate Control Measure not equal to Yes

Thanks in Advance.

3 Replies
prat1507
Valued Contributor

Re: Set Expression Issue

Maybe this

Sum({<

Level={'Critical'},

Submission date - report run date ={'> 7.0'},

Status-={'Closed'},

[Intermediate Control Measure]-={'Yes'}

>}

Value)

Regards
Pratyush

saniyask
Contributor

Re: Set Expression Issue

Hi,

Please refer to the below blog.

Dates in Set Analysis  and Set Analysis: syntaxes, examples

Regards,

Saniya.

agigliotti
Honored Contributor II

Re: Set Expression Issue

I suggest you to create a new field in your script as below:

(Submission date - report run date) as Date_Diff

then

Sum( {< Level = {'Critical'}, Date_Diff = {'>7'}, Status -= {'Closed'}, [Intermediate Control Measure] -= {'Yes'} >} Value)

Community Browser