topic Show total by dimension in QlikView

Show total by dimension

varunreddy — Mon, 21 May 2018 20:03:06 GMT

Hi All,

I have a pivot table and I am trying to display the distinct count at the end of the dimension.

Current Report:

In the above screen Shot, I am trying to calculate distinct Number by Type and Name either by using the straight or pivot table as shown below in the "Expected Output".

Expected Output:

Attaching the source file and the QVD. Can anyone please help me with this?

Re: Show total by dimension

vishsaggi — Mon, 21 May 2018 20:25:58 GMT

try this in your expr and in presentation tab enable Show partial sums check box.

= IF(Dimensionality() = 2, Count(DISTINCT Number), Severity)

Re: Show total by dimension

varunreddy — Mon, 21 May 2018 20:40:38 GMT

Hi Nagaraju,

Thanks for your quick response

Cheers,

Varun