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: 
kev6brown
Partner - Creator
Partner - Creator

Max Date

My data looks like -

IDDateColour
12301/01/2019Green
12302/01/2019Green
12303/01/2019Green
12304/01/2019Green
12101/01/2019Green
12102/01/2019Green
12103/01/2019Green
12104/01/2019Green
12201/01/2019Blue
12202/01/2019Blue
12203/01/2019Blue
12204/01/2019Blue
12401/01/2019Yellow
12402/01/2019Yellow
12403/01/2019Yellow
12404/01/2019Yellow

What i need is a count of the max date by colour....the date is a filter though

once that date is selected, I need another column stating the count for the day before the selected date

Any ideas?

Kev

 

6 Replies
kev6brown
Partner - Creator
Partner - Creator
Author

might not have explained what I need to see. basically, a date filtered and from that I would want to see

ColourDate (filtered)Count of IDDate (filtered Yesterdays Date)Count of ID
Green02/01/2019201/01/20192
Blue02/01/2019101/01/20191
Yellow02/01/2019101/01/20191

My data example isn't the best but hopefully you get the idea

JordyWegman
Partner - Master
Partner - Master

Hi Kev,

In you do this in the front-end, you can use:

Measure: Max(Date)
Dimension: Colour

And this for the day before

Date(Floor(Only(Date))-1),'DD/MM/YYYY')

Jordy

Climber 

Work smarter, not harder
kev6brown
Partner - Creator
Partner - Creator
Author

thanks

i need a count too, so date doesn't need to appear but i need the count of ID's

iswarya
Partner - Creator
Partner - Creator

Measure: Count(Colour)

kev6brown
Partner - Creator
Partner - Creator
Author

if i just count colour then the date won't be taken into consideration

iswarya
Partner - Creator
Partner - Creator

In a straight table,  add date as dimension and measure as count(colour)