Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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