Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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)