Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Greater than set analysis issue


Hello,

I have two tables, one containing the details of every machine which isn't working and the reported date of the status (as well as Country, Product Line, etc). I also have another table with the total amount of machines (installed base) per Region and Product Line at certain periods (I have a "from" and "to" date for each Region-Product Line combination). I'm linking both tables per Region-ProductLine. What I want to do is divide the amount of non-working machines in a certain month by the installed base in the period that month is located into. I've tried the following expression but it ain't working:

sum   (   {  < IB.FromDate={"<=Calendardate"},  IB.ToDate ={">=Calendardate "}   >}   distinct IB)

The tables I have look like the following:

Table 1:

Machine IDRegionProduct LineCalendardateLink
1AmericaA

03/08/2014

AmericaA
2EuropeB08/08/2014EuropeB
3AmericaB15/08/2014AmericaB
4AmericaB25/09/2014AmericaC

Table 2:

LinkIB.FromDateIB.ToDateIB
AmericaA01/11/201301/09/201410
AmericaB01/11/201301/09/20148
EuropeA01/11/201301/09/20145
EuropeB01/11/201301/09/20147

So what I'd want is to get the following table for AUGUST:

Region\Product LineAB
America1/102/8
Europe0/51/7

Please help me solve this issue and get the right formula. Thanks a lot in advance

Community Browser