12 Replies Latest reply: Mar 25, 2013 8:57 AM by Raajesh Nagarajan RSS

    How to find the MaxDate for a Calculated Expression

    Raajesh Nagarajan

      Hi QlikViewers,

       

      Requesting your help here. I have a Straight Table in QlikView Application. In addition to this chart, I have multiple filters. Chart will be responding to the selections made in these filters. Each time the selection is made, the max month may change depending upon the filters.


      Table.png      Table2.png

       

      Now, will it be possible for us to get the Max Month from the above chart (in the first case, it will be Mar-13 and 91 - and in second case it will be Dec12)? Essentially, I would want to display the max month, min month and total number of months shown in the chart in a separate text objects.

       

      Appreciate your support.

       

      Thanks & Regards,

       

      Raajesh N