8 Replies Latest reply: May 14, 2018 4:03 PM by Miguel R RSS

    How to show only rows with 1 or 2 missing data in table?

    Miguel R

      Hi Community, would be wonderful if you could help.


      I would like to have an expression (Straight Table) where the table only show rows where Value and/or Status values are blank. (Not in the script)

       

      'Data':

      Load* Inline [

       

      Date | Value | Status

       

      21-04-2018 | 321 | 1

      22-04-2018 | 421 | 2

      23-04-2018 |  |

      24-04-2018 | 123 | 1

      25-04-2018 | 431 |

      26-04-2018 | 212 |

      27-04-2018 | | 2

      28-04-2018 | 434 | 1

      29-04-2018 | |

      30-04-2018 | |1

       

      ] (delimiter is '|');

       

      Ideal result in Qlik Sense Table:

       

      Date              Value      Status

      23-04-2018

      25-04-2018    431

      26-04-2018    212

      27-04-2018                      2

      29-04-2018

      30-04-2018                      1

       

      Thanks in advance!