I have created a table in qlikview that has the collumns 'Day', 'Topic', and 'Shop Talk'. I want to only display the rows where 'Shop Talk' has a value. I've been using the following statement, but it is not working
if
(Len([Shop Talk]) > 0, Only(Day))
Where do i put this expression? I'm not exactly sure where to put it. I cant seem to get it to work.
To me those look like fields that are blank (just spaces in them) not technically null which would be displayed as '-" instead of just a blank box. In the script use the trim command on shop talk:
Trim([Shop Talk]) as [Shop Talk]
That should solve your issue as long as the checkbox is checked to omit null rows.
