Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Expression problem

Capture.JPG

=sum({$ < [Claim Desc] = ,[Claim Nature] = >}INSP_EVENT_CNT)  is use to find out the total and it works

I want to add a column to count where the insp_type_desc is material

Any suggestion? I am not familiar with using analysis, thank you!

Tags (2)
1 Solution

Accepted Solutions
arulsettu
Honored Contributor III

Re: Expression problem

may be this

sum({$ < [Claim Desc] = ,[Claim Nature] =,INSP_TYPE_DESC={'Material'} >}INSP_EVENT_CNT) 

4 Replies
arulsettu
Honored Contributor III

Re: Expression problem

may be this

sum({$ < [Claim Desc] = ,[Claim Nature] =,INSP_TYPE_DESC={'Material'} >}INSP_EVENT_CNT) 

Re: Expression problem

Hi,

close {} and "" in your set analysis

sum({$ < [Claim Desc] = ,[Claim Nature] =,INSP_TYPE_DESC={"Material"} >}INSP_EVENT_CNT)


Regards

Great dreamer's dreams never fulfilled, they are always transcended.
manishnarang
Contributor

Re: Expression problem

use INSP_TYPE_DESK = {'Material'} inside expresion

Not applicable

Re: Expression problem

I appreciate it, thank you so much!!!