Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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