Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Max Month

Hi

   Table1:

DateMAR
2015-03-19ABC124
2015-02-20ABC34
2015-03-21ABC5656

   

Table2:

   

Att_DateLogTypeDuration
2015-03-19Present450
2015-02-20Present621
2015-04-21Present458
2015-03-20Present420

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

2 Replies

Re: Max Month

So do you need only march data in table 2?

stigchel
Honored Contributor

Re: Max Month

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))

Community Browser