Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expressions with different dimensions in same chart

Hi everyone,

I have a chart with two expressions. The first expression must have one dimension and the second expression must have a different dimension. In my case, it doesn't work using the conditional option on dimensions tab. Is it achievable using another method?

Any ideas are welcome.

Thank you.

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Use for example Sum(Total <field1, field2...> expr.)

JonnyPoole
Former Employee
Former Employee

Can you post a screenshot of what you are trying to achieve ?

Not applicable
Author

Sounds like you just need to enter the expressions differently.

i.e

expression 1 (current year) would be:

sum({$<Year={$(=Only(Year))}>}qty)

expression 2 (previous year) would be:

sum({$<Year={$(=Only(Year)-1)}>}qty)

But you would need to post what you are looking to acheive