topic Re: Max Month in QlikView

Max Month

Wed, 15 Jul 2015 13:35:58 GMT

Table1:

Table2:

Based on Max Month available in Table 1 , Duration in Table 2 to be summed up and shown up for the same month ,

In the above ex : Duration of March to be summed up

Kushal_Chawda — Wed, 15 Jul 2015 13:48:17 GMT

So do you need only march data in table 2?

stigchel — Wed, 15 Jul 2015 13:50:38 GMT

Do you need this in load script or in the front end? In front end you can use

=Sum(if(Month(Att_Date)=$(=Max(Month(Date#(Date,'YYYY-MM-DD')))),Duration))