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

Keep count when I select value

Hi guys,

I have a table with url, where I calculate avg and counts.

I'd like, when I select any comment, in the table shown only this url and the total count for this url.

Other words,

I select "All the internet tools offered by are awesome" from list box and in the table

myaccount..net/internettools/datausage/usage.     shows 4.3 and 70

Capture.PNG.

1 Solution

Accepted Solutions
MarcoWedel

Hi,

one solution could be to add a set expression like

{$<Why=, Url=p(Url)>}

to your chart expressions:

Avg({$<Why=, Url=p(Url)>}Score)

Count({$<Why=, Url=p(Url)>}Url)

QlikCommunity_Thread_146183_Pic1.JPG

hope this helps

regards

Marco

View solution in original post

3 Replies
MarcoWedel

Hi,

one solution could be to add a set expression like

{$<Why=, Url=p(Url)>}

to your chart expressions:

Avg({$<Why=, Url=p(Url)>}Score)

Count({$<Why=, Url=p(Url)>}Url)

QlikCommunity_Thread_146183_Pic1.JPG

hope this helps

regards

Marco

Anonymous
Not applicable
Author

Thank you, Marco

MarcoWedel

You're welcome

regards

Marco