Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Frquiroga1995
Contributor II
Contributor II

Filter Data on a Straight Table

Hi ! This is an example of my databse (days is a expression which calculates the difference between Date1 and Date2).

I would like a Straight Table object in the front, that only shows the records where estado_principal = Pendiente.

nrointernoDate1Date2estado_principaldays
4086920/4/202120/4/2021Pendiente10
4086720/4/202120/4/2021Pendiente10
4089220/4/202120/4/2021Pendiente10
4089420/4/202120/4/2021Pendiente10
4086320/4/202120/4/2021Pendiente10
4086620/4/202120/4/2021Aprobado por Operaciones16
4086820/4/202120/4/2021Aprobado por Operaciones14
4087320/4/202120/4/2021Anulado por Operaciones14

 

Thanks !

1 Reply
rwunderlich
Luminary Alumni
Luminary Alumni

The set is:

{<estado_principal={'Pendiente'}>}

You can use it in the days expression, or make estado_principal column like:

=Aggr(Only({<estado_principal={'Pendiente'}>} estado_principal), estado_principal)

-Rob