Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tan_chungkam
Creator
Creator

Conditional Show/Hide in Qlik Sense

Hi all,

Happy Monday Blue.

Please find attached my qvf and excel file for your references.

I would like to hide the null values as shown below but without affect the shown dates.

Null value with Full DatesNull value with Full DatesIf I unchecked 'Include Null Value' the full date is gone.If I unchecked 'Include Null Value' the full date is gone.

Labels (2)
2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

I am not sure what you mean by "hiding the null values". Do you want to replace the '-' in the cell? Do you want to suppress the entire line? You apparently do not want to suppress the columns.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
tan_chungkam
Creator
Creator
Author

Hi @jonathandienst ,

Thanks for helping out.

I just wanna show full dates  (from 1st to 31st of every month) without the '-' in Technician column. 

It is like the above 2nd screenshot.

The month of January only show 1st -10th. I would like to make it to become 1st -31st for every month.

I don't mind if you have any ways to remove or replace the '-'.

Hope i did explained well enough here.