topic Re: PIVOT - One row in details that has not to be showed in QlikView

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

clovati — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 05 Dec 2016 12:05:42 GMT

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 — Mon, 05 Dec 2016 12:23:48 GMT

Another option (using vinieme12‌'s sample)

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

vinieme12 — Mon, 05 Dec 2016 12:25:25 GMT

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 — Mon, 05 Dec 2016 12:28:18 GMT

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))