Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Last result from selected date range

Hi,

Apologies but I am rather new to this whole set up. This question appears to have come up before but the solution doesn't seem to have the desired effect I am after and possibly I am making an error.

In the image you can see my table and I have highlighted in red which is simply a SUM of all the Open figures by day. Whoever built this table did this wrong as this is meant to be what is outstanding in the queue at the end of the chosen period.

How can I get this to bring back the figure for the Max date of the selection?

I have tried something like the following but I get 0

=SUM({$<QueueStartDate = {'$(='QueueStartDate'(MaxDate))'}>} QueueVolumeStillOpen)

Again apologies I'm rather fresh on the scene with Qlik.

Thanks

1 Solution

Accepted Solutions
shraddha_g
Honored Contributor III

Re: Last result from selected date range

Try

sum({<QueueStartDate = {"$(=max(QueueStartDate))"}>}QueueVolumeStillOpen)

5 Replies
shraddha_g
Honored Contributor III

Re: Last result from selected date range

Try

sum({<QueueStartDate = {"$(=max(QueueStartDate))"}>}QueueVolumeStillOpen)

galax_allu
Valued Contributor

Re: Last result from selected date range

Dual(If(QueueStartDate=Max(QueueStartDate), WorkQueue,''),Sum(QueueVolumeStillOpen))

cazztfplease
Contributor

Re: Last result from selected date range

sum({$<QueueStartDate = {(max(QueueStartDate))}>}QueueVolumeStillOpen)

Not applicable

Re: Last result from selected date range

Thank you this appears to have worked.

Not applicable

Re: Last result from selected date range

This one didn't work and instead seems to bring back the WorkQueue name

Community Browser