Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor III

Set expression

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

2 Replies
Highlighted
Valued Contributor

Re: Set expression

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

Highlighted
Valued Contributor II

Re: Set expression

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.