Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Hide null values in a measure

Hi,

I am comparing two dates, one of which is calculated using a variable which is assigned from a user input in the front end.

This is displaying a table of initiatives, and I wish to hide rows which do not have their initiative name displayed (as the dates haven't fulfilled the requirements)

The calculation is below:

if(max({ $<[Timeline Content]={"CLD"}> } [Timeline Start Date]) <> max( { <[Timeline Content] = {'.'}> * <[Timeline Start Date] = {'<=$(=$(vTest1))'} > } [Timeline Start Date] ),[Initiative Name])

This is a measure (due to operators such as MAX), if it was a dimension I could 'hide null values' for this column. Any suggestions as to how I could get rid of them and only display rows which satisfy the above algorithm?

Thanks

0 Replies