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.

[rbecher]

Hi,

I can not see any AMOUNT field in the data model...

- Ralf

[#3]

Please Sir RALF

The name of AMOUNT field is : MONTANT

Cheers

[rbecher]

Yimen,

don't call me a SIR.. 😉

I presumed this, what is wrong with your expression?

Btw, I suggest to use a moth field (as a dimension) for things like that...

- Ralf

[#5]

I got it but I wish that for other lines that do not amount it shows zero.

[brenner_martina]

Hi,

I do not understand, what's your problem, the expression is right! Look at my uploaded file!

[#7]

The problem is, you have the CENT metric with the same condition.

If you have same condition, it will hide the null value rows.

Regards,
Srini.

[#8]

Gael,

if you want the same result for every line use total as

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

you can add breaks on dimension as well

cordialement

christian

[#9]

My problem is the follow:

I want to have the same result when we desactivate the CENT metric.

Is it possible?

[brenner_martina]

Hi,

hide the 0 is easy:

If(SUM

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

SUM

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