topic Re: Number of fields calculation in QlikView

Number of fields calculation

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

Guys,

I have a table as shown below,

I want to get the count of FieldName for the fields which are having same WithPropID.

As per this data, I need the result as 1 - FieldName (SHPM_IDEN_NO) having same WithPropID (4).

Thanks,

Siva.

m_woolf — Fri, 28 Jul 2017 18:31:33 GMT

=count(<{FieldName={'SHPM_IDEN_NO'}}> WithPropID)

vinieme12 — Fri, 28 Jul 2017 18:34:39 GMT

Can you post the sample in excel and also the expected output!

Anonymous — Fri, 28 Jul 2017 18:35:57 GMT

No, I don't want the count of WithPropID. I want the FieldName count which has same WithPropID.

Anonymous — Fri, 28 Jul 2017 18:37:54 GMT

Attached sample data, and my output is 1.

i.e Count(FieldName) which has same WithPropID.

antoniotiman — Fri, 28 Jul 2017 18:58:55 GMT

Hi,

maybe this

=Count({<FieldName={'=Count(DISTINCT WithPropID)=1 and Count(WithPropID) > 1'}>} DISTINCT FieldName)

=Concat({<FieldName={'=Count(DISTINCT WithPropID)=1 and Count(WithPropID) > 1'}>} DISTINCT FieldName,' - ')

Regards,

Antonio

vinieme12 — Fri, 28 Jul 2017 19:13:04 GMT

Try below , this will check for exact combination of each value in Fieldname, WithPropID and Length

Dimension

Fieldname

Expression

=sum(AGGR(if(count(DISTINCT TOTAL <FieldName> FieldName&Length&WithPropID)=1 and count(FieldName)>1 ,1,0),FieldName))

or if you only need fieldname and withpropid combination, remove length from the expression

sum(AGGR(if(count(distinct total <FieldName> FieldName&WithPropID)=1 and count(FieldName)>1 ,1,0),FieldName))

Anonymous — Fri, 28 Jul 2017 19:44:50 GMT

Thanks Vineeth. But using this expression, I couldn't expect my output.

vinieme12 — Fri, 28 Jul 2017 20:01:54 GMT

works for me!