topic Re: Expression problem in QlikView

Expression problem

Wed, 25 Nov 2020 16:16:04 GMT

=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!

arulsettu — Thu, 14 Jul 2016 09:09:19 GMT

may be this

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

PrashantSangle — Thu, 14 Jul 2016 09:09:27 GMT

Hi,

close {} and "" in your set analysis

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

Regards

manishnarang — Thu, 14 Jul 2016 09:09:42 GMT

use INSP_TYPE_DESK = {'Material'} inside expresion

Thu, 14 Jul 2016 09:13:27 GMT

I appreciate it, thank you so much!!!