PIVOT - One row in details that has not to be showed

[clovati]

Hi all and thanks in advance.

In qlikview, in  my pivot there are 2 dimensons and one is the 'master', the other is 'details'.

I want to hide/not to show the details when the number of details is one (and total is the same as details).

This is an example.

thanks in advance and have a good day!

Cristina

[vinieme12]

Add a calculated dimension for "master" as below and check , Suppress when value is null

=AGGR(IF(COUNT(dIStinct total  <master> detail) >1,master),master)

[sunny_talwar]

Another option (using vinieme12‌'s sample)

If(Dimensionality() = 1 or Count(TOTAL <master> master) > 1, Sum(amount))

[vinieme12]

Another Variant

Dimensions:

Diminesion1:   master

Diminesion2:   =AGGR(IF(COUNT(dIStinct total  <master> detail) >1,detail),master,detail)

Expression:

if(SUM( TOTAL<master> AGGR(count(DISTINCT TOTAL <master> detail),master))=1 AND Dimensionality()=2,NULL(),SUM(amount))

[sunny_talwar · Accepted solution]

I like the idea of doing a distinct count of details here instead of count of master

If(Dimensionality() = 1 or Count(DISTINCT TOTAL <master> details) > 1, Sum(amount))