Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can qlikview take a "clicked" item and count it?

I'm trying to write an app where it counts the number of lines by person

Say everybody is listed and has multiple entries, but I want to click around and see it change. I know if you do =count(owner) and then click in the GUI, it will move around, but can I make it do =count(owner "when clicked") or something like that? so it knows it's looking for a click?

5 Replies
joshabbott
Creator III
Creator III

What do you mean by 'number of lines by person'?  The number of rows in a straight table?  What are they clicking?  A person?

Not applicable
Author

yes, column "Owner" is one of my objects. If they click John Q. Public, I want it to count how many times his name appears in the table.

joshabbott
Creator III
Creator III

Like in a text box?  Here is my first thought, do you have a unique value like in this instance, ProjectID on the table?

 

=if(COUNT(DISTINCT Owner) = 1, COUNT(ProjectID), '')

Not applicable
Author

no but I can get one added very very easily, and it wouldn't detract from what I'm trying to do. I'll give it a shot, thank you!

joshabbott
Creator III
Creator III

Sure, and if it is in a straight table, you shouldn't need to add that new value to the straight table, just use it in the code for where you are trying to display the count