Problem with a Qlikview application

[#1]

Hello community.

I am currently developing a small application Qlikview.

Here is the file attachment.

In fact, I want to sum the amounts depending on the direction of DATEECR.

Here's an example: For the month of March, I wrote the formula but I have no results:

SUM ({$ <SENS = {"D"}, DATEECR ={">= 01/03/2011 <= 31/03/2011 "}>} AMOUNT)

What makes the connection between my two tables is the field IDFORMULE.

Thank you for your help.

[brenner_martina]

Hi, Gael,

the right expression in:

=Sum(AGGR(Sum({<DATEECR={">=01/03/2011 <=31/03/2011"}>}
If(SENS=SENSFORM,MONTANT,0)),LIBRUB,LIBSSSGPE,LIBSSGPE,LIBSGPE))

[#3]

Srinivasan wrote:
Ho you expect this result ?

I get this when i uncheck Suppress zero value. <div></div>

Yes that is what i want.

Please can you tell me the expression that you use in Mars metric?

thanks

[#4]

Hi, i have just attached the qvw. I'm using QV 10. I just unchecked the Suppress Zero Values.

[#5]

Srinivasan wrote:
Hi, i have just attached the qvw. I'm using QV 10. I just unchecked the Suppress Zero Values. <div></div>

Thank you Sir Srinivasan.

I have posted a new topic.

Please Please, I want you to look.

[#6]

Gael,

you should create an other table dedicated only to dates. This table won't be attached to the model. You then can use it as a reference instead of DATEECR like SUM( { $< SENS={"D"}, DATEAMJ01={MONTHECR} > } MONTANT)

create a date like 01/MM/YYYY from MONTHECR from DATEECR. for each DATEECR. Easier to compare with DATEAMJ01 hosting every month under date format

regard

christian