topic Re: Count appearances of same value in different fields in QlikView

Count appearances of same value in different fields

Tue, 16 Jun 2015 10:22:45 GMT

Hi,

I have the subsequent table in my Qlikview application;

How can I get Qlikview to Count the following;

How many time are the values in field VT_Oprettetaf the same as the value listed in IKO_Oprettetaf

Thanks in advance

Martin Elboth Palm

datanibbler — Tue, 16 Jun 2015 10:29:07 GMT

Hi Martin,

try like >> Count(IF(VT_Oprettetaf = IKO_Oprettetaf, 1)) <<

HTH

Tue, 16 Jun 2015 10:36:59 GMT

Hi DataNibbler,

Thank you so much, just the right calculation I needed