Discussion board where members can learn more about Qlik Sense App Development and Usage.
Show/ Hide complete column with 'Null' or 'no Values' in straight Table.
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)
- Check "Supress When value is null" is one option
- May be write calculated condition : If(Len([Request Type])>0, [Request Type])
- Enable Calculate condition for Coulmn.If like... If(IsNull([Request Category]), 0,1)
Thanks @Anil_Babu_Samineni . For Que 2, its not working.
My case it is working, check once