How to hide column when field values is empty

[NavinReddy]

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

[m_woolf]

Maybe:

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

[NavinReddy]

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 

[m_woolf]

Can you attach a sample qvw?

[NavinReddy]

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

[woudatje]

 = If (Provider <> '' , Provider)

??