topic Re: Expressions with different dimensions in same chart in QlikView

Expressions with different dimensions in same chart

Thu, 23 Oct 2014 13:03:20 GMT

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.

Re: Expressions with different dimensions in same chart

alexandros17 — Thu, 23 Oct 2014 13:06:17 GMT

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

Re: Expressions with different dimensions in same chart

JonnyPoole — Thu, 23 Oct 2014 13:06:24 GMT

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

Re: Expressions with different dimensions in same chart

Thu, 23 Oct 2014 13:16:37 GMT

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