8 Replies Latest reply: Nov 26, 2015 6:18 AM by Stefano Caminiti RSS

    Sub Totali

    Stefano Caminiti

      Hello Qlik Community

      I'm a new Qlik user and as rookie I need your pleasant help.

       

      As first question I would like to know if I can create sub total by field, and if yes how do that?

      Second question is linked to the formula usage. In detail my need is to create a delta, as the picture enclosed, per each single month, in comparison with same month in previous year. Looking around I have found a formula which use the max() but create only one result while I need it for all the rows.

       

      The formula is: SUM ({<[YEAR]= {"$(=MAX([YEAR]))"} REV) and including the -1 to find the previous year. I have also tried to change the formula without the max() but doesn't work

       

      thanks in advance for your support

      have a nice day

       

      ciaooo