Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
Qlik Connect 2025! Where innovative solutions turn your data visions into reality: REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Jérôme5625
Creator
Creator

Automatic filtering of a table

Hello,
first of all, happy new year 2023 to all.
Attached is a screenshot of a table.
I would like to filter the ORDER column according to the "ZOFSUIVI_250" field. the orders should be displayed ONLY if ZOFSUIVI_250 is empty. I tried with a set analysis but I can't find the right syntax to filter according to an empty field. Can you help me? Thank you
Thank you for your help.

Labels (2)
1 Reply
pedrobergo
Employee
Employee

Hi @Jérôme5625 

If the Z0FSUM_R.280 column is a dimension on your table, please use this formula:

=if(isnull([Z0FSUM_R.280]),'',Null())

 

And uncheck 'Include null values'.

pedrobergo_0-1672671135046.png

 

[],

Pedro