Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
danaleota
Contributor II
Contributor II

Grouping for a line graph

Hello I am trying to do a line graph of number of deaths over time grouped by individual country.  Year is my dimension and sum(deaths) is my measure.  I also wanted to only include a few years I just entered '1999' for now but this is what I tried so far and its not working. 

 

 =sum(total Aggr (sum({$<Year = 1999}>} Deaths),Country)  

any help would be great thanks.  

 

Labels (4)
1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

For your set analysis

 =sum(total Aggr (sum({$<Year = {1999}}>} Deaths),Country)  

your curly brackets around the year value are missing

If you want a line per Country you can add it as a second dimension.

View solution in original post

1 Reply
Lisa_P
Employee
Employee

For your set analysis

 =sum(total Aggr (sum({$<Year = {1999}}>} Deaths),Country)  

your curly brackets around the year value are missing

If you want a line per Country you can add it as a second dimension.