topic Re: Set expression in QlikView

Set expression

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Iam using the below expression as set analysis..

sum({<PDJira_Status=,PDJira_Severity={'Severity 1'}>}PDCloseCount)

can please any experty confirm me that ...

Iam using PDJira_Status= , will this incluse the values which are within this field ?

I mean will it sum PDCloseCount associating the values in PDJira_Status and PDJira_Severity ???

Thanks

kakani87 — Sat, 31 Mar 2018 05:51:52 GMT

Yes .... but when PDJira_Status is selected no data will be filtered accordingly

Nagaraju_KCS — Sat, 31 Mar 2018 14:59:42 GMT

Yes Roy,

sum({<PDJira_Status=, PDJira_Severity={'Severity 1'}>}PDCloseCount)

Whenever you select PDJira_Status=, it won't effect because your excluding filter.

Your expression SUM only for PDJira_Severity equals to 'Serverty1'

Have a look sample attached data.