Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table - choosing field - Qliksense

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

1 Reply
brunobertels
Master
Master

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