Filter out empty string values

Filter out empty string values

Posted by: bnguyen on 25 January 2024, 5:01 am EST

• 

  bnguyen

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 25 January 2024, 5:01 am EST

  How do we filter out empty string values in charts?

  Currently have some data set to empty string: ‘’ in the database. How can we add a filter to ignore these values? Also for Null values.

  Filter with !=NULL or !=“” does not work

• 

  katyayny.raghuvanshi

  

  • Post Options:
  • Link
    Copy

  Posted 28 January 2024, 4:58 pm EST

  Hi,

  Could you please try to elaborate on the issue in more detail so that we can assist you further? Please provide us with more information regarding the following:

  • Report type (RDL/Page/Section)
  • Chart plot type
  • Use case

  Looking forward to your response!

• 

  bnguyen

  • Post Options:
  • Link
    Copy

  Posted 29 January 2024, 1:41 am EST - Updated 29 January 2024, 1:46 am EST

  Hello,

  I am using RDL report trying to create a column chart. I have attached a screenshot

  

• 

  katyayny.raghuvanshi

  

  • Post Options:
  • Link
    Copy

  Posted 29 January 2024, 3:07 pm EST

  Hi,

  You may use the following expression in chart filters to filter out empty values:

  = [Level1] > 0

  Hope this helps!

  Attachment:ColumnChartSample.zip