How to hide column in Qlik Cloud UI

[Mounika4]

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?

[E_Røse]

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.

[rwunderlich]

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

[Mounika4]

Thanks for your response ,

I tried as you showed but it didn't work 

[Mounika4]

Exactly ,so in qliksense is there any  alternative way ?

[E_Røse]

@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? 

[rwunderlich]

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