topic count if value in two columns are the same in QlikView

count if value in two columns are the same

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a hierarchy data set and there are cases where parent level and child level are sharing the same value.

There are two things that I want to do with that.

1. count the number of rows that share the same value for PARENT and CHILD

2. actually filtering for those rows so that I can bring them in to excel file.

for the first question I was thinking about writing something like

count( distinct if ( PARENT = CHILD), PARENT)

but it does not seem to work.

and for the second one I have no clue at the moment.

Please help!

Thank you!

Re: count if value in two columns are the same

Clever_Anjos — Tue, 30 Aug 2016 16:36:24 GMT

Maybe

Sum(

If( PARENT = CHILD, 1, 0 )

)

Re: count if value in two columns are the same

ankali1990 — Tue, 30 Aug 2016 16:42:26 GMT

Hello,

you could create flags in the script and after that to sum them in the layout. I prefer to do that instead of sum(if()).

Regards

Re: count if value in two columns are the same

abhi1693r — Wed, 26 Jun 2019 18:23:24 GMT

Hi Stephan,
I had a similar issue. So I have two columns, PART AND CUBES, with one to many relationship.(one PART can have many CUBES or a PART can have no CUBE).
Scenario: If I select 3 PARTS which have 2 CUBES, wherein 2 PARTS have 2 CUBES and 1 PART has no CUBE. I want a count of all the CUBES plus any PART which has no CUBES.

PART	CUBES
SW1001	1415TV
DC1003	1516TD
BW1002

So the count should be 2+1=3.
How can I implement this?

Regards,
Abhishek