topic Epression in QlikView

Epression

aveeeeeee7en — Tue, 06 May 2014 06:52:35 GMT

Hi Community

I have 2 Expressions & 1 Dimension in my Straight Table:

Dimension:

Month

Expressions:

1) Sum(Left)

2) Sum(Closed)/12

I am Creating New Expression:

3) Sum(Left)/Column(2) - It is Working & Giving Me the Result.

4) Sum(Left)/Sum(Closed)/12 - It is Not Working & Not Giving Me the Result.

Am I doing something wrong in the Expression???

How to Resolve No.4) Issue??

ashfaq_haseeb — Tue, 06 May 2014 07:00:03 GMT

Hi try below

4) Sum(Left)/(Sum(Closed)/12) - It is Not Working & Not Giving Me the Result.

Hope it help.

Regards

ASHFAQ

alexandros17 — Tue, 06 May 2014 07:00:24 GMT

I should have to know the data but try this:

1) Sum(Left/Closed)/12

Verify that sum(Closed) is not 0 otherwise you will have a null value

er_mohit — Tue, 06 May 2014 07:00:31 GMT

Try this way

sum(Left)/(Sum(Closed)/12)

if its null value then didn't show to show 0 value

in presentation tab-->uncheck suppress zero value

Anonymous — Tue, 06 May 2014 07:03:28 GMT

Try like this

Sum(Left)/(Sum(Closed)/12)

column(1)/column(2)