Discussion Board for collaboration related to QlikView Deployment.
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.
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?
Go to Solution.
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.