Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You could catch this with a query on the dimensionality maybe like:
if(dimensionality() = 1, Expression2)
- Marcus
You could catch this with a query on the dimensionality maybe like:
if(dimensionality() = 1, Expression2)
- Marcus
Hi, try with :
=if(RowNo()=1,Expression2)
Thank you! That worked.