Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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!

1 Solution

Accepted Solutions
arulsettu
Master III
Master III

may be this

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

View solution in original post

4 Replies
arulsettu
Master III
Master III

may be this

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

PrashantSangle

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
manishnarang
Partner - Creator
Partner - Creator

use INSP_TYPE_DESK = {'Material'} inside expresion

Not applicable
Author

I appreciate it, thank you so much!!!