topic Re: Keep count when I select value in QlikView

Keep count when I select value

Anonymous — Wed, 17 Dec 2014 21:39:40 GMT

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

MarcoWedel — Thu, 18 Dec 2014 00:20:14 GMT

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)

hope this helps

regards

Marco

Anonymous — Thu, 18 Dec 2014 15:08:50 GMT

Thank you, Marco

MarcoWedel — Thu, 18 Dec 2014 15:23:15 GMT

You're welcome

regards

Marco