Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

A Table Showing Data for Just 1 Value in a Field

Hi,

I need a little help in trying to create a table. I've probably been thinking too hard about it and confusing the issue.

I have 3 fields, Date, Country and NumberOfDownloads.

The number of downloads for the same 5 countries are recorded for each day. So, each day has 5 countries, each with 1 download value.

I simply want to create a table that in column 1 shows the date, column 2 shows the country and column 3 shows the download value. However, I only want the table to show 1 of the countries, say CountryA.

So, it's almost like having a table with CountryA selected, but I don't want CountryA selected.

I'm pretty sure it can be done with some set analysis, but that can get confusing sometimes and i'm not sure which column it should be applied to.

Thanks in advance.

1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

Hi Darren

use the set expression

{<Country={'CountryA'}>}

in the expression, ie:

sum({<Country={'CountryA'}>} NumberOfDownloads)

hth/gg

View solution in original post

2 Replies
Highlighted
Specialist II
Specialist II

Hi Darren

use the set expression

{<Country={'CountryA'}>}

in the expression, ie:

sum({<Country={'CountryA'}>} NumberOfDownloads)

hth/gg

View solution in original post

Highlighted
Contributor II
Contributor II

Hi,

Thanks for your quick response, it works perfectly.