Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Count appearances of same value in different fields

Hi,

I have the subsequent table in my Qlikview application;

image001.png

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

Tags (3)
1 Solution

Accepted Solutions
datanibbler
Esteemed Contributor

Re: Count appearances of same value in different fields

Hi Martin,

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

HTH

2 Replies
datanibbler
Esteemed Contributor

Re: Count appearances of same value in different fields

Hi Martin,

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

HTH

Not applicable

Re: Count appearances of same value in different fields

Hi DataNibbler,

Thank you so much, just the right calculation I needed

Community Browser