topic Re: Date Set Analysis in QlikView

Date Set Analysis

has75042 — Wed, 25 Nov 2020 16:16:04 GMT

I am trying to implement set analysis, where if user selects a date, I want to show cash amount up-to that date.

This is the Set Analysis I am using, but is not working

=sum({<CalendarLink={$(<=(CalendarLink))}>}total_cash_price)

For example,

If user select 6/1/2019, I want to show all the cash amount upto 6/1/2019.

Re: Date Set Analysis

has75042 — Fri, 14 Jun 2019 20:16:57 GMT

=sum({<CalendarLink={'$(=only((CalendarLink)))'}>}total_cash_price)
This one is working, however I need to change is to all the amount less than selection date

Re: Date Set Analysis

Vegar — Fri, 14 Jun 2019 21:10:22 GMT

Try this expression:

=sum({<
CalendarLink={"<=$(=only(CalendarLink))"}
>}total_cash_price)

Re: Date Set Analysis

has75042 — Wed, 19 Jun 2019 15:23:45 GMT

Thanks. It worked.