topic Re: Pivot table total with missing values in QlikView

Pivot table total with missing values

Tue, 12 Apr 2016 05:33:50 GMT

Hi,

Is it possible to change pivot table total row value depending on what kind of data is available? I have a table where I need to show earliest project information update dates. If the date is missing, the row should say "not updated". If multiple projects are chosen and one project in the group has missing update date, pivot table's total row should also return "not updated".

It's easy to show date value if it exist and "not updated" if it doesn't exist:

if(isnull([Update Date]), 'Not updated', min([Update Date]))

However the total row also displays a value that results from min([Update Date]. Is there way of telling total row to ignore date field if there are missing values in selected group?

Re: Pivot table total with missing values

settu_periasamy — Tue, 12 Apr 2016 14:56:22 GMT

May be look the Dimensionality() function.

Re: Pivot table total with missing values

trdandamudi — Tue, 12 Apr 2016 15:00:03 GMT

Please look into Dimensionality() or SecondaryDimensionality()

Re: Pivot table total with missing values

Kushal_Chawda — Tue, 12 Apr 2016 15:33:27 GMT

see this, the use case of Dimensionality()

Custom total calculation in Pivot table