topic Re: Set analysis in QlikView

Set analysis

maxime66 — Mon, 09 Feb 2015 14:44:37 GMT

Hi !

I would like to get ( in the Blue text box of the Qkw file joined ),the sum(CA1) for January 2014 (100 €).

This box must report for each month of "Date_ca" the sum(CA1) for the previous year (don't know if very clear )

Thanks for your time.

Re: Set analysis

Anonymous — Mon, 09 Feb 2015 14:49:26 GMT

Hi Maxime, try this:

=sum( {1 <annee_mois={ "$(=left(Date_ca,4)-1 & '/' & $(=mid(Date_ca,5,2) ) )"} > } CA1)

Re: Set analysis

reshmakala — Mon, 09 Feb 2015 14:53:34 GMT

Find attached solution

Re: Set analysis

Anonymous — Mon, 09 Feb 2015 15:01:16 GMT

This is correct, but why don't use date formatting functions instead of string functions. It is much easier:

=sum( {1 <annee_mois={ "$(=date(addyears(date#(Date_ca,'YYYYMMDD'),-1),'YYYY/MM'))"} > } CA1)

Re: Set analysis

maxime66 — Mon, 09 Feb 2015 15:07:24 GMT

Thanks Michael, Works perfectly !

You're right, date formatting is better !

Re: Set analysis

Anonymous — Mon, 16 Feb 2015 14:31:40 GMT

Hello maxime66, please close the thread selecting what answer was helpful or the solution, in order to help the rest of users to search threads with correct answers.

Thank you.