set analysis problem

[#1]

hi folks,

i have data from 2007 to 2011

i have one chart expression as

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

but when i select 2011 year field , this chart displays no data display.

how to exclude perticular year in set analysis.

[CELAMBARASAN]

Hi,

     You mean like this or something else?

     sum({<InvoiceStatus={'o'},Year-={2011}>} InvoiceCollectedAmountSys)

Celambarasan

[#3]

Hi,

  Did you checked the year 2011 having the InvoiceStatus with 'o'?

-Jai

[#4]

hi,

in 2011 there is no records which is related to invoice status 'O'.

how can i exclude from the selection in set analysis

[jvitantonio]

Rag, if you have no data 2011 and yuo select 2011 it is ok that thechart doesn't show anything. What do you expect to see?????

[lalitinmbd]

Try the below formula-

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

[CELAMBARASAN]

Hi,

     What do you mean by excluding here?

     What result you need to get on selecting 2011?

Celambarasan

[lalitinmbd]

Below Expression will exclude the selection on Year.

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