topic Re: Dimension(Column) missing in Pivot when there is Null in QlikView

Dimension(Column) missing in Pivot when there is Null

Tue, 24 Jan 2017 14:21:39 GMT

Hi All,

I have created a Pivot table using below data.

I want to show data for "Department", "City" and "State" when both "Name" & "EMP Name" matches. It's working fine when i look at complete data.

But i am facing issue when i selected single record(where "Name" and "EMP Name" is different.

I want to see all the dimensions in the pivot table even it has null(Due to my condition).

Can anyone help me on this.

Thanks in Advance!!

krishnacbe — Tue, 24 Jan 2017 14:28:42 GMT

In pivot table you wrote the conditional expression to hide the values. Instead of null values try with N/A or some other text values.

Pivot table nature is there is no value in Department column, so it hides city and State.

CarlosAMonroy — Tue, 24 Jan 2017 14:48:24 GMT

Hi Krishna

You can try adding values:

=IF(Name=[EMP Name], Department,'')

Thanks,

Carlos

sunny_talwar — Tue, 24 Jan 2017 15:17:30 GMT

May be this

=if(Name=[EMP Name], State, Dual('-', 1))

Fri, 10 Mar 2017 08:11:26 GMT

Above Like Sunny reply

PFA

Try like this

if(Name=[EMP Name],sum(Amount))

and uncheck the presenattiontab>supress zero values option