Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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