Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Null Column

Hello I have a pivot table

i have several columns
i use in one column the after expression.
so i can show the difference between the same columns of two years.

2014                            2013
  

number difference       number     difference

100        50                   50                 -

e.g. 2014 difference from 2013. but the difference column of 2013 is empty. all null values.

Is it possible to not showing this empty column?

1 Solution

Accepted Solutions
Employee
Employee

Re: Null Column

IF the whole column has nothing but nulls or zeroes you can suppress it using these properties circled below.

additionally, a common trick is put an IF expression on the expression to make it zero or null based on a condition... then use these to remove the unwanted rows/columns as well.

Capture.PNG.png

1 Reply
Employee
Employee

Re: Null Column

IF the whole column has nothing but nulls or zeroes you can suppress it using these properties circled below.

additionally, a common trick is put an IF expression on the expression to make it zero or null based on a condition... then use these to remove the unwanted rows/columns as well.

Capture.PNG.png

Community Browser