Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
santho_ak
Partner - Creator III
Partner - Creator III

Show/ Hide complete column with 'Null' or 'no Values' in straight Table

Show/ Hide complete column with 'Null' or 'no Values' in straight Table. 

Actual :

sashokku_2-1610387820831.png

 

I am able to hide the 'Salary' column using the condition Count(Salary)>0 or Sum(Salary)>0. (Not sure if it is right but it works)

Que 1: However, I need to hide 'Request Type' column whenever there is no data/ null.

 Que 2: Hide 'Request Category' column whenever it is Null (Empty space and '-' as well)

Required:

sashokku_1-1610387797541.png

 

Labels (3)
3 Replies
Anil_Babu_Samineni

Check these

Que 1: However, I need to hide 'Request Type' column whenever there is no data/ null.

- Check "Supress When value is null" is one option

- May be write calculated condition : If(Len([Request Type])>0, [Request Type])

 Que 2: Hide 'Request Category' column whenever it is Null (Empty space and '-' as well)

- Enable Calculate condition for Coulmn.If like... If(IsNull([Request Category]), 0,1)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
santho_ak
Partner - Creator III
Partner - Creator III
Author

Thanks @Anil_Babu_Samineni . For Que 2, its not working.

Anil_Babu_Samineni

My case it is working, check once

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)