New to Qlik Sense

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results 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.

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.