# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

## Multiple Measures Plotted by Year

The task at hand is to plot the number buys in each media type (Newspaper, TV, Magazine, etc) for the last five years.  In a line chart, I set a dimension of year and a measure of type.  I created a measure for each type and created an expression such as: if (pubType='TV',aggr(count(pubType),jobYear),0))

This seems to work if a salesperson has buys of only one media type, if they have buys for 2015 in newspaper and TV, it plots nothing.

I have played with some set analysis expressions but can’t seem to get past this issue.

The attached image shows 3 newspaper buys in 2015 and 7 in 2014.  2013 should show 8 billboard, 1 newspaper and 1 online.  It is at this point that my expression breaks.

Can anyone point me in the right direction on this one?

1 Solution

Accepted Solutions
MVP

## Re: Multiple Measures Plotted by Year

The expressions should be like (with dimension of Year)

Count({<pubType = {'TV'}>} pubType)

But if pubType is also a dimension, then all you need is

Count(pubType)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
3 Replies
MVP

## Re: Multiple Measures Plotted by Year

The expressions should be like (with dimension of Year)

Count({<pubType = {'TV'}>} pubType)

But if pubType is also a dimension, then all you need is

Count(pubType)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP

## Re: Multiple Measures Plotted by Year

I have answered, but it has gone into moderation for no obvious reason...

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

## Re: Multiple Measures Plotted by Year

Awesome! I've been trying everything under the sun...hard to believe I didn't try that...