Table - choosing field - Qliksense

[#1]

I have a table

ID    Linear     Date

1      100         30/6/2015

2       110         30/6/2015

1        112        31/7/2015

2         111        31/7/2015

3          123       31/7/2015

When I choose the ID - I want to only use the linear with the dates 31 July 2015 - but not sure how to do this in Qliksense

Any thoughts please

Teresa

[brunobertels]

Hi Teresa

In your Table

Add ID as dimension and Linear as Dimension

Then as mesure add this :

Count({$<Date={'31/07/2015'}>}Linear) // will count the number of Linear field by distinc ID only for this Date

you will get this

Regards

Bruno