topic set analysis problem in QlikView

set analysis problem

Mon, 27 Feb 2012 10:45:57 GMT

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 — Mon, 27 Feb 2012 10:51:36 GMT

Hi,

You mean like this or something else?

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

Celambarasan

Mon, 27 Feb 2012 10:56:08 GMT

Hi,

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

-Jai

Mon, 27 Feb 2012 11:20:39 GMT

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 — Mon, 27 Feb 2012 11:24:07 GMT

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 — Mon, 27 Feb 2012 11:32:52 GMT

Try the below formula-

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

CELAMBARASAN — Mon, 27 Feb 2012 11:38:44 GMT

Hi,

What do you mean by excluding here?

What result you need to get on selecting 2011?

Celambarasan

lalitinmbd — Mon, 27 Feb 2012 12:35:23 GMT

Below Expression will exclude the selection on Year.

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