QlikSense - Pivot Table - Only Function

[Bashar]

Hello,

You see a pivot table and a straight table, for some reason I'm getting nulls in the pivot table if I leave out certain  dimension out, even though, in the straight table you can see that there is a value for each combination.

I'm using the following expression Price in both tables.

If(isNull(StylePrice),Only({<isCurrentSKUPrice={'1'}>}ItemPrice),Only({<isCurrentSKUPrice={'1'}>}StylePrice))

Looking at the first row in the straight table, StylePrice is null, so get me the only ItemPrice which has the "Current" flag = 1. It does that until I remove some of the columns.

Working: (With SeasonCode)

Not working . (Without SeasonCode) - Price List

[BrunPierre]

@Bashar maybe this?

If(isNull(StylePrice) and isCurrentSKUPrice='1',
Aggr(Only(TOTAL <SeasonCode> ItemPrice),Style,Option,[Item Number]),
Aggr(Only(TOTAL <SeasonCode> StylePrice),Style,Option,[Item Number]))

[Bashar]

Hello @BrunPierre 

Thank you for the response, but this didn't quite work out as expected.

[Bashar · Accepted solution]

Just to close this, I did a workaround where "IsCurrentSKUPrice" value '1' gets selected and deselected as needed to keep the value from showing nulls.