topic Something wrong with the Expression in QlikView

Something wrong with the Expression

Tue, 26 Jul 2011 04:37:03 GMT

Hi All:

Not sure where I went wrong with the Expression in the MTD variance

The Expression is as follow:-

Sum (if(Year= year(CurrentDate) and Month1 = month(CurrentDate)
and (transdate)<= CurrentDate,[Day Variance]

My problem is on the Day Variance as the above expression...

The Day Varaince = Crate To - Crate From

Day Variance is in the Expression (Colum 3) and MYD Variance (Colum4)

After the calculation in the expression (Crate TO – Crate From) I should be able to use the field right?

Hmmm... something is wrong

Could someone please share some light?

perumal_41 — Tue, 26 Jul 2011 04:39:59 GMT

Sum (if(Year= year(CurrentDate) and Month1 = month(CurrentDate)

and (transdate)<= CurrentDate,[Day Variance]))

Tue, 26 Jul 2011 04:59:29 GMT

Hi Perumal A:

Thanks for your help but the issue is on the Day Variance...

Not about the )))...

When [Day Variance] is key in there is an Error on top the expression:- Bad Field name : [Day Variance]

Not sure what went wrong....

perumal_41 — Tue, 26 Jul 2011 05:32:52 GMT

please upload ur file.

Tue, 26 Jul 2011 06:11:55 GMT

Hi Perumal A and All:

I just up load the file...

The issue is in the MTD variance.

Where I use the Day Variance for my MTD variance.

Can take a look at the Expression in MTD variance.

Thanks all