Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
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)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

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

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

View solution in original post

6 Replies
Highlighted
MVP
MVP

Try the line expression like:

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

Highlighted
Creator
Creator

Hello,

 

Thank you for the respons,

but this gives me a very over the top result.

Any ideas?

Screenshot_1.jpg

 

Highlighted
MVP
MVP

Could you explain the issue a bit more?

Highlighted
Creator
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.

Highlighted
MVP
MVP

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

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

View solution in original post

Highlighted
Creator
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.