Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
t_hylander
Creator
Creator

Two date field comparision in set analysis

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!

Labels (2)
1 Reply
sunny_talwar

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

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