Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Expressions with different dimensions in same chart

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

Employee
Employee

Re: Expressions with different dimensions in same chart

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

Not applicable

Re: Expressions with different dimensions in same chart

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

Community Browser