topic Re: main num in QlikView

main num

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

hii good morning to all

i am having a problem in this

this is my code

"=if(len(CLM_XGEN_CLAIM_NUM)<=16,Count({<CLM_LEVEL_OF_CARE={'Secondary'}>}distinct CLM_XGEN_CLAIM_NUM))"

this is my column below

CLM_XGEN_CLAIM_NUM

RC-HS15-10319322-1

RR-HS15-10340556

in this i dnt want the supplementary 'CLM_XGEN_CLAIM_NUM' coun i want only main count only

as given below

EG :

RC-HS15-10319322-1

RR-HS15-10340556

so count should be 1 as main claim is RR-HS15-10340556

can anyone help me in this

Re: main num

PrashantSangle — Thu, 14 Jul 2016 06:25:21 GMT

Hi,

try like

=if(len(CLM_XGEN_CLAIM_NUM)<=16 and len(KeepChar(CLM_XGEN_CLAIM_NUM,'-'))=2,Count({<CLM_LEVEL_OF_CARE={'Secondary'}>}distinct CLM_XGEN_CLAIM_NUM))

Regards

Re: main num

tresB — Thu, 14 Jul 2016 06:29:06 GMT

Try like:

Count({<CLM_XGEN_CLAIM_NUM={"=len(CLM_XGEN_CLAIM_NUM)<=16"}, CLM_LEVEL_OF_CARE={'Secondary'}>}distinct CLM_XGEN_CLAIM_NUM)

Re: main num

sagarrahul — Thu, 14 Jul 2016 06:39:54 GMT

ty max

this is my table

CLM_XGEN_CLAIM_NUM	CLM_INTIMATION_DATE	CLM_LEVEL_OF_CARE	ICD_CODE_LEVEL1_org	Claim_Type	ICD Code Blacklist	total count of claims
RC-HS15-10318402-1	22-Jan-2016	Secondary	J34.2	-	1	-
RC-HS15-10318402-2	09-Feb-2016	Secondary	J34.2	-	1	-
RC-HS16-10352325	17-May-2016	Secondary	K76.2	-	1	1
				-	3	-

as there are 3 claims but i want only main claim in my total count of claims column that is 1

but its not showing its total in yellow column .

can u help me in this

Re: main num

tresB — Thu, 14 Jul 2016 06:47:46 GMT

Did you try the expression I suggested above? So you want all three rows to be displayed, but the count to work or one, right? Could you post your sample qvw?

Re: main num

sagarrahul — Thu, 14 Jul 2016 06:56:20 GMT

ur expression is showing error

Re: main num

PrashantSangle — Thu, 14 Jul 2016 06:59:01 GMT

Hi,

tresesco solution is correct just missed to closed " in set analysis.

Count({<CLM_XGEN_CLAIM_NUM={"=len(CLM_XGEN_CLAIM_NUM)<=16"}, CLM_LEVEL_OF_CARE={'Secondary'}>}distinct CLM_XGEN_CLAIM_NUM)

try that solution.

Regards,

Re: main num

sagarrahul — Thu, 14 Jul 2016 06:59:54 GMT

i want this output

CLM_XGEN_CLAIM_NUM	CLM_INTIMATION_DATE	CLM_LEVEL_OF_CARE	ICD_CODE_LEVEL1_org	Claim_Type	ICD Code Blacklist	total count of claims	Value	status
RC-HS15-10318402-1	22-Jan-2016	Secondary	J34.2	-	1	-	0.000	Outlier
RC-HS15-10318402-2	09-Feb-2016	Secondary	J34.2	-	1	-	0.000	Outlier
RC-HS16-10352325	17-May-2016	Secondary	K76.2	-	1	1	1.000	Outlier
				-	3	1	1.000	Outlier

Re: main num

tresB — Thu, 14 Jul 2016 07:02:04 GMT

Thanks max. Good catch. Corrected now.