Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hiding a column if condition occurs on Straight table


Hi,

I have a Straight table with multiple fields/columns.I have a requirement to hide a column Post_Address when Post_Address=NA for a particular ID

and another column Child_Num when Child_Num=0 for list of ID's.

already tried with the below

if(Post_Address<>'NA',Post_Address)

SubStringCount(Concat(ID,'|'),1002)>>0

If(IsNull(POSTAL_CD),0,1)         ---->This is not applicable

Please suggest if anyone have any idea?

Thanks in advance.

11 Replies
Not applicable
Author

Just Repeat the Only() function with an OR in between.

If( Only(Post_Address) = 'NA' OR Only(Post_Address) = '0', 0 , 1)

Not applicable
Author

Cheers..

Thanks Matthew