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.

[#2]

And so the value of SENS must equals SENSFORM before to do the calculation...

@ HOPECOVE : Your formula don't give me the good result.

[#3]

Did you tried property under presentation tab and uncheck the "Suppress Zero-Values" ?

Regards,
Srini.

[#4]

@ Martina

Please Martina, assume that you delete the CENT metric.

I want to show the result without hide the 0 for the others lines.

[#5]

Gael,

look at it

christian

[#6]

Srinivasan wrote:
Did you tried property under presentation tab and uncheck the "Suppress Zero-Values" ?
Regards,
Srini. <div></div>

Yes under presentation tab, i have unchecked the "Suppress Zero-Values"

[#7]

Ho you expect this result ?

I get this when i uncheck Suppress zero value.

[rbecher]

Easy as this:

= SUM(if(month(DATEECR)=3, MONTANT, 0))

- Ralf

[#9]

HOPECOVE wrote:
Gael,
look at it
christian<div></div>

It's not what i want

May be you don't hear my problem ?

Ok I explain it a second time.

The two table FORMULE and ECRITURE are linked by the field IDFORMULE.

For a line of FORMULE table, we have many lines of ECRITURE table.

What i want is the follow:

In the line of FORMULE, there is the field SENSFORM. I want to calculate the SUM of line which have the same IDFORMULE by using

SENSFORM = SENS, DATEECR in the date of each month.

Thanks

[#10]

Ralf Becher wrote:
Easy as this:
 <blockquote><pre>= SUM(if(month(DATEECR)=3, MONTANT, 0))

- Ralf

The result is exact but the others lines are hide.

I want that the others lines are displaying.

[rbecher]

You also have to uncheck "Suppress Zero-Values" in Presentation Tab!

- Ralf