Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sarasmonu
New Contributor III

Hide Columns with 0s

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

5 Replies
mdmukramali
Valued Contributor II

Re: Hide Columns with 0s

Hi,

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

286577.PNG

sarasmonu
New Contributor III

Re: Hide Columns with 0s

Hi ,

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

Thanks

mdmukramali
Valued Contributor II

Re: Hide Columns with 0s

Hi,

Can you share sample application file let me check.

radoresky
Contributor

Re: Hide Columns with 0s

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

MVP
MVP

Re: Hide Columns with 0s

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