# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a \$200 Amazon Gift Card! Watch Video
cancel
Showing results for
Search instead for
Did you mean:
Creator

## Static measure line in chart

Good day to all.

I have a question, I think it will be simple,

but i can be mistaken.

I Have a combograph where results are displayed per month.

dimension: Month

Measure: sum(amount)

The Line measure is = sum(if(soort = 'OMZET', Amount))

Now this Line measure should become static no matter what the selection is.

So if the customer selects a certain account, the bars adjust to this selection, but the total of the line measure stays the same.

So if the customer select all accounts with number 62, the bars adjust, but the line stays the same.

So that the customer can see the relation between this.

If any questions,

I will be happy to answer.

Thanks in advance

Dries

Labels (1)
• ### static measure

1 Solution

Accepted Solutions
MVP

For specific (I am using 2019 in example) year data, try like:

sum( {1<soort = {'OMZET'}, Year={'2019'}>} Amount)

6 Replies
MVP

Try the line expression like:

sum( {1<soort = {'OMZET'}>} Amount)

Creator

Hello,

Thank you for the respons,

but this gives me a very over the top result.

Any ideas?

MVP

Could you explain the issue a bit more?

Creator

I think I know whats going on,

so it's all the years combined.

So I would need a measure that only looks at the year dimension, but ignores the rest,

is this even possible?

Right now the line always shows all years combined.

MVP

For specific (I am using 2019 in example) year data, try like:

sum( {1<soort = {'OMZET'}, Year={'2019'}>} Amount)

Creator

Thank you,

this gets me close,

but still more than it should be,

but that's probably something in my data model!

I thank you good sir.

Tags