Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using a straight table to populate country,count and clicks.I want to show the sum of clicks obtained for selected countries.I am using the expression 'count({<Country={'USA','India','UK','Canada'}>}Country)' to populate the count column and this show only the selected countries and when i add another expression 'sum(clicks)' to show sum of clicks each selected country got,then table shows count of all the countries from my source excel.Below attached is my sample qlikview file
Add the same filter to the sum expression too: sum({<Country={'USA','India','UK','Canada'}>}clicks)
Add the same filter to the sum expression too: sum({<Country={'USA','India','UK','Canada'}>}clicks)
You need the set analysis on the 2nd expression as well.
Sum({<Country={'USA','India','UK','Canada'}>}Clicks)
Hi thank you for the help it worked for me
Hi thank you for the help