topic Re: Output data for only latest date(TodayDate) in QlikView

Output data for only latest date(TodayDate)

vikneesh25 — Sat, 16 Nov 2024 01:01:30 GMT

Hi,

I want my chart to only populate data based on latest QVD and not all. I tried running this expression but it still gives me the total of all QVD's and not the latest one.

=SUM({<Date={"<=$(=Date(Today()))"}>}TOTAL_CASES)

How do i do it?

Re: Output data for only latest date(TodayDate)

Taoufiq_Zarra — Thu, 19 Mar 2020 09:25:47 GMT

Hi,

I think the problem is in the expression

What you do here is return the data with the date less than or equal to today, so if the date of the last QVD is today the expression will return all the data, so it's normal.

so if you want to calculate only on the last QVD either at script level you can add a Flag that identifies the last QVD or if the last QVD is today's date then you can change <= to =.

Otherwise you can share a sample data to help you better.

Re: Output data for only latest date(TodayDate)

Brett_Bleess — Tue, 14 Apr 2020 15:02:35 GMT

Following Design Blog post my be helpful too, but if Taoufiq's post is what you needed, please be sure to close out your thread by using the Accept as Solution button on his post. If you did something different, consider posting that and then use the button on that post to close the thread.

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

Regards,
Brett