topic Re: How to hide column when field values is empty in QlikView

How to hide column when field values is empty

NavinReddy — Tue, 31 Mar 2020 17:22:11 GMT

Hello All,

can some one help me How to hide column when field values is empty. i have tried below expression its not working for me.

=if(Len( [Provider])=0,0,1)
=if(count( [Provider])=0,0,1)
if(count( [Provider])=null(),1,0)
sum([Provider])>0
If(Len(Trim([([Provider])]))<>0 , [([Provider])])

Regards,

Navin

Re: How to hide column when field values is empty

m_woolf — Tue, 31 Mar 2020 19:12:03 GMT

Maybe:

max(len(Provider))>0 to show the column

Re: How to hide column when field values is empty

NavinReddy — Tue, 07 Apr 2020 12:25:01 GMT

Good Evening @m_woolf , Thanks for your reply

i have tried with max(len(Provider))>0 expression not hiding the empty fieds data. Any suggestions please

Re: How to hide column when field values is empty

m_woolf — Tue, 07 Apr 2020 12:27:20 GMT

Can you attach a sample qvw?

Re: How to hide column when field values is empty

NavinReddy — Tue, 07 Apr 2020 21:13:42 GMT

@m_woolf sorry for security reason I do no have access to attache the file. Any suggestions please

Re: How to hide column when field values is empty

woudatje — Wed, 08 Apr 2020 15:54:14 GMT

= If (Provider <> '' , Provider)