Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mishraamit2485
Creator
Creator

Suppress null values in the expression

Hi All,

I"m facing one issue, without checking the box(Suppress when value is null),can i achieve same thing in the expression.

my expression is something like this.

=IF(Index(GetSelectedField,LATEST_BOOKMARK,') > 0,

if(BOOKMARK=LATEST_BOOKMARK, Hello), Hello)

after the first hello it is returning null, and if i check suppress when value is null it is hiding the entire row where the null value is present for that column(Which is impacting the other calculations as I have multiple dimension in the straight table).

Suppose i have three book mark 1,2,3 and 3rd one is the latest(getting it from the max(entrydate) column) so the moment user select the latest bookmark it should hide the others(1,2) and display the latest.

2 Replies
sujeetsingh
Master III
Master III

You can use dimension limit to handle this

mishraamit2485
Creator
Creator
Author

It is just showing the first record all the time, but i need something where it should show all the record but the moment i hit latest bookmark it should show only latest record.