Set Value of Expression to Zero if Dimension has one Value

[max_potass]

Hello everyone,

I have a small Problem I can't find anything about in the Documentation or here...

I want to create a Pivot Chart with 2 Dimensions and 2 Expressions.

One of the Expressions only has Values for the first Dimension. So Qlikview is "pasting" these values for the second Dimension.

I want these values in the second Dimension to be zero.

I guess I need an "If" and a functions that tells me, if the current 2nd Dimension has one specific value. But GetSelectedCoumt does obviously not work, as it is not an selection. I need something similar which works here, right?

Does anyone has an Idea, how to fix this?

I have:

I want:

Best regards

Max

[marcus_sommer · Accepted solution]

You could catch this with a query on the dimensionality maybe like:

if(dimensionality() = 1, Expression2)

- Marcus

[sergio0592]

Hi, try with :

=if(RowNo()=1,Expression2)

[max_potass]

Thank you! That worked.