Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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
MVP
MVP

Try the line expression like:

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

Creator
Creator

Hello,

 

Thank you for the respons,

but this gives me a very over the top result.

Any ideas?

Screenshot_1.jpg

 

MVP
MVP

Could you explain the issue a bit more?

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.

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

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.