Hide Columns with 0s

[sarasmonu]

Hi,

I have a pivot table with multiple measures in column. I do not want those columns to be displayed where all values in the column is 0.

Please let me know if there is any workaround to get this done.

Thanks,

Monu

[mdmukramali]

Hi,

have you tried the option in Add-Ons --> Data Handling -> Un-Check the Include zero Values

[sarasmonu]

Hi ,

Yes i have, it hides all the rows with 0s.

Thanks

[mdmukramali]

Hi,

Can you share sample application file let me check.

[RadovanOresky]

Hi Monu,

I don't think you can automatically hide columns which have 0 in all rows in a Qlik Sense pivot table. Maybe if you would use a ValueList() function in a calculated dimension that would use Aggr() to check each row for a 0, but that would be a very unsustainable solution.

If you really need to have the table adjustable, I suggest you let the user to define which measures will be shown. This can be achieved either by utilizing variables along with the qsVariable extension, or using the Custom Report extension, which you can find on the Qlik Branch.

Regards,

Radovan

[stevedark]

Hi Monu,

There is no 'out of the box' way to hide columns in Qlik Sense.  It would be a good ting to put in as a feature request though, as it is something that is just a tick box in QlikView.

You may want to look at an extension that gives you table functionality and more configuration options, such as the VizLib table ( Vizlib | Blog ) .  If you have any questions on whether this would be a good fit for you mahlerma is the man.

Hope that helps,

Steve

[MaryseC]

Cognos does that buil-in.  You can do "zero suppression in row, columns or both".  Now we are recreating cognos reports in qlik and users don't understand why we are not able to hide columns with zeros :S