topic Re: How to hide column in Qlik Cloud UI in Visualization and Usability

How to hide column in Qlik Cloud UI

Mounika4 — Wed, 08 Mar 2023 09:57:27 GMT

Actually we are migrating qlikview applications to qlikcloud

In qlikview straight table we have hide option to hide the column (Means that columns should be there ,but won't display to users)

But in qlikCloud/Qliksense we dont have hide functionallity.,

So i gave 0 in show column if as below snap

That column get hide but sorting order not working here

other case , i tried to remove labels in filed/column and in text color expression i gave white() .everting working as expected but..the issue is

see the below snap ,it will showing like this ..how to overcome this? or is there anyway to hide the columns?

Re: How to hide column in Qlik Cloud UI

E_Røse — Tue, 07 Mar 2023 20:37:59 GMT

I am not sure I understand exactly what you want to do here? You can hide a column with 0 in the hide column option. That worked right? If you want to sort by the hidden column, you can sort another column by expression, and type the name of the hidden column in the expression.

Please like and mark my answer as a solution, if it resolved your issue.

Re: How to hide column in Qlik Cloud UI

rwunderlich — Tue, 07 Mar 2023 23:44:36 GMT

I think the difference here is that in QlikView, a hidden column "exists", it just does not display. The column hidden by Presentation > Hide Column may be referenced by another expression for sorting etc.

In Qlik Sense, a column hidden by "Show column if" is not calculated -- ie "Show if" is a calculation condition. The hidden column therefore does not exist and can't be referenced by another expression.

-Rob

Re: How to hide column in Qlik Cloud UI

Mounika4 — Wed, 08 Mar 2023 05:15:52 GMT

Thanks for your response ,

I tried as you showed but it didn't work

Re: How to hide column in Qlik Cloud UI

Mounika4 — Wed, 08 Mar 2023 05:26:10 GMT

Exactly ,so in qliksense is there any alternative way ?

Re: How to hide column in Qlik Cloud UI

E_Røse — Wed, 08 Mar 2023 08:45:02 GMT

@Mounika4 It is easier to help you if you explain why you need that the column is there, but hidden as in QlikView?

Is it for sorting?

Re: How to hide column in Qlik Cloud UI

rwunderlich — Wed, 08 Mar 2023 15:27:34 GMT

In Qlik Sense, you use the expression itself rather than referring to a "hidden column". That could be the actual expression text, a master measure or a variable.

-Rob