topic filter the date in QlikView

filter the date

bhagi — Fri, 15 Nov 2024 23:49:05 GMT

Hi all,

I created a calendar, and I added a filter in my application with the dates of this calendar.

I wish use calendar dates as a filter for my data.

For example if the user chose the 01/01/2019 I have the sales of 01/01.

How can i get?

thanks

bhagi

avinashelite — Tue, 13 Oct 2020 05:35:09 GMT

Link your data table and calendar with the date key and add the filter in the front end app .....not sure what your looking for !!

Chanty4u — Tue, 13 Oct 2020 08:35:50 GMT

hi,

what is your expected output? and how you want to show?

if you want like below

may be in calendar create field like

day(Yourdate) as day

and use it as filter

Chanty4u — Tue, 13 Oct 2020 08:36:33 GMT

or may be

Do you want to display Sales of that selected Date?

Then you can try

Sum({<Date = {"$(=Max(Date))"}>} Sales)