topic AW:Problem with a Qlikview application in QlikView

Problem with a Qlikview application

Wed, 27 Apr 2011 10:03:37 GMT

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.

Problem with a Qlikview application

rbecher — Wed, 27 Apr 2011 10:13:03 GMT

Hi,

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

- Ralf

Re. :Re: Problem with a Qlikview application

Wed, 27 Apr 2011 10:21:45 GMT

Please Sir RALF

The name of AMOUNT field is : MONTANT

Cheers

Re. :Re: Problem with a Qlikview application

rbecher — Wed, 27 Apr 2011 10:32:53 GMT

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

Re. :Re: Re. :Re: Problem with a Qlikview application

Wed, 27 Apr 2011 10:36:16 GMT

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

AW:Problem with a Qlikview application

brenner_martina — Wed, 27 Apr 2011 10:39:11 GMT

Hi,

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

Re. :Re: Re. :Re: Problem with a Qlikview application

Wed, 27 Apr 2011 10:41:44 GMT

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.

Re. :Re: Re. :Re: Problem with a Qlikview application

Wed, 27 Apr 2011 10:45:32 GMT

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

Re. :Re: Re. :Re: Re. :Re: Problem with a Qlikview application

Wed, 27 Apr 2011 10:46:45 GMT

My problem is the follow:

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

Is it possible?

AW:Problem with a Qlikview application

brenner_martina — Wed, 27 Apr 2011 10:47:34 GMT

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) ,'')

Re. :Re: Re. :Re: Re. :Re: Problem with a Qlikview application

Wed, 27 Apr 2011 10:51:21 GMT

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

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

Re. :Re: Re. :Re: Re. :Re: Problem with a Qlikview application

Wed, 27 Apr 2011 10:52:06 GMT

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

Regards,
Srini.

Re. :AW:Problem with a Qlikview application

Wed, 27 Apr 2011 10:54:33 GMT

@ Martina

Please Martina, assume that you delete the CENT metric.

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

Problem with a Qlikview application

Wed, 27 Apr 2011 10:56:45 GMT

Gael,

look at it

christian

Re. :Re: Re. :Re: Re. :Re: Re. :Re: Problem with a Qlikview application

Wed, 27 Apr 2011 10:57:46 GMT


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"

Re. :Re: Re. :Re: Re. :Re: Re. :Re: Problem with a Qlikview application

Wed, 27 Apr 2011 11:03:40 GMT

Ho you expect this result ?

I get this when i uncheck Suppress zero value.

Re. :Re: Re. :Re: Re. :Re: Re. :Re: Problem with a Qlikview application

rbecher — Wed, 27 Apr 2011 11:04:49 GMT

Easy as this:

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

- Ralf

Re. :Re: Problem with a Qlikview application

Wed, 27 Apr 2011 11:10:16 GMT


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

Re. :Re: Re. :Re: Re. :Re: Re. :Re: Re. :Re: Problem with a Qlikview application

Wed, 27 Apr 2011 11:12:59 GMT


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.

Re. :Re: Re. :Re: Re. :Re: Re. :Re: Re. :Re: Problem with a Qlikview application

rbecher — Wed, 27 Apr 2011 11:25:53 GMT

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

- Ralf