Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
datanibbler
Champion
Champion

Hi Martin,

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

HTH

View solution in original post

2 Replies
datanibbler
Champion
Champion

Hi Martin,

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

HTH

Not applicable
Author

Hi DataNibbler,

Thank you so much, just the right calculation I needed