Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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