Two date field comparision in set analysis

t_hylander — Sat, 16 Nov 2024 04:37:40 GMT

Hi,

I have a table, something like this;

LOAD * INLINE [
    Date, Orderdate, Total
    2018-08-10, 2018_29, 4
    2018-09-24, 2018_33, 1
    2018-09-26, 2018_34, 2
    2018-10-12, 2018_36, 1
];

The Orderdate is year_week-format. What I want is to select a month (from mastercalendar) and then in a textbox show the total number of orders that was made the weeks during the selected month.

So with the above data, selecting september would result in 1 order (2018_36), selecting august would result in 3 orders (2018_33 + 2018_34).

I know this is wrong but something like this;

=count({<Orderdate=Year_Week>} Total)

It rings a bell somwhere in the back of my head, but cant figure it out at the moment.

Thanks!

Re: Two date field comparision in set analysis

sunny_talwar — Tue, 29 Jan 2019 16:32:11 GMT

Is this always based on selection? If it is, then may be this

=Count({<Orderdate = P(Year_Week), Year_Week>} Total)

topic Re: Two date field comparision in set analysis in QlikView

Two date field comparision in set analysis

Re: Two date field comparision in set analysis