topic Re: writing expression for only the more recent date in QlikView

writing expression for only the more recent date

Wed, 25 Nov 2020 16:16:04 GMT

Hi! I numeric value that comes in every day and my table looks like

and I want to write a expression for a pie chart that only brings in the last day's value.

how do I do this??

Thank you in advance!!

sunny_talwar — Tue, 03 Jan 2017 22:34:46 GMT

May be like this:

Assuming Header 1 is a number and not date

Sum({<[Header 1] = {"$(=Max([Header 1]))"}>}[Header 2])

Assuming Header 1 is a date and not number

Sum({<[Header 1] = {"$(=Date(Max([Header 1]), 'YYYYMMDD'))"}>}[Header 2])

Tue, 03 Jan 2017 22:51:10 GMT

Hi!

This works perfectly !! just one more question. can I add one more if statement within the sum?? for example [Header 3] = 'Y' ?

Thank you so much!

sunny_talwar — Tue, 03 Jan 2017 22:54:52 GMT

Sure, may be like this:

Sum({<[Header 1] = {"$(=Max([Header 1]))"}, [Header 3] = {'Y'}>}[Header 2])

Sum({<[Header 1] = {"$(=Date(Max([Header 1]), 'YYYYMMDD'))"}, [Header 3] = {'Y'}>}[Header 2])

Tue, 03 Jan 2017 23:22:40 GMT

AMAZING!!! Thank you