topic Problem with SET ANALYSIS in QlikView

Problem with SET ANALYSIS

Wed, 13 Apr 2011 12:14:41 GMT

Hello community.

I have a problem.

I have a table based on the EXCEL attached file.

I have loaded this file py this statement:

ecriture:

LOAD CDOS, NUMCPT, SENS, MONTANT, DATEECR, PERIODE, MOIS, ANNEE, TRIMESTRE, NUMCPT1, NUMCPT2, NUMCPT3, NUMCPT4 FROM (biff, embedded labels, table is Sheet1$);

I use the following statement

= SUM ($ {<NUMCPT={"56*"}+{"57*"}+{"58*"}, SENS={"D"}, DATEECR> = {"01 / 03/2011 '}, DATEECR <= {"31/03/2011"}>} MONTANT)

to get results but nothing appears.

The problem then is my formula or something else?

Thank you

Problem with SET ANALYSIS

stephencredmond — Wed, 13 Apr 2011 12:24:45 GMT

The syntax is simpler than that:

SUM ($ {<NUMCPT={"56*"}+{"57*"}+{"58*"}, SENS={"D"}, DATEECR> = {"01 / 03/2011 '},DATEECR <= {"31/03/2011"}>} MONTANT)

SUM ($ {<NUMCPT={"56*","57*","58*"}, SENS={"D"}, DATEECR = {">01/03/2011<=31/03/2011"}>} MONTANT)

Regards,

Stephen

Problem with SET ANALYSIS

stephencredmond — Wed, 13 Apr 2011 12:31:24 GMT

Sorry - also need to move the $ after the {, not before it:

SUM ( {$<NUMCPT={"56*","57*","58*"}, SENS={"D"}, DATEECR = {">01/03/2011<=31/03/2011"}>} MONTANT)

Re. :Re: Problem with SET ANALYSIS

Wed, 13 Apr 2011 15:12:42 GMT

Thanks Sir Stephen Redmond.

It's OK