invoice status

[#1]

hi gurus,

i have data like this
invoice number   invoice status  invoice amount
yin1                          o                   10000
yin2                          c                       0
yin3                          NULL                20000

i created  3 charts to each invoice status
problem is in the dash board if i click invoice status 'o', in another chart(Null) its displaying no data display.

how to achieve association among these 3 charts.

all source data in one excel file only

[jvitantonio]

Hi, I'm not sure about you comple data set, but if you made 1 graphic for each invoce, there's only 1 invoce with status o, and therefore you'll have infor in only 1 of the charts and the rest will be null.

If this is not the case, please upload your application example so we can work on it.

[CELAMBARASAN]

Hi,

     Cann't understand clearly little more briefer please.

Celambarasan

[#4]

hi,

plz find the attached sample qvw.

Thanks in Advance.

[jvitantonio]

RAGHAVA,

The problem is that in your chart expression you have this formula:

sum(if(InvoiceStatus='o',InvoiceCollectedAmountSys))

/(sum(if(InvoiceStatus='o',InvoiceTotalAmountSys)))*90

And this will sum only those with status O. If you choose NULL this formula has nothing to SUM.

If you want to make it general, delete the IF part of the sum function

[CELAMBARASAN]

Hi,

     Instead of this formula

     sum(if(InvoiceStatus='o',InvoiceCollectedAmountSys)) make it to

     use this set of expressions

     sum({<InvoiceStatus={'o'}>}InvoiceCollectedAmountSys)

     sum({<InvoiceStatus={'c'}>}InvoiceCollectedAmountSys)

     sum({<InvoiceStatus={'NULL'}>}InvoiceCollectedAmountSys)

Celambarasan