topic invoice status in QlikView

invoice status

Fri, 24 Feb 2012 10:14:42 GMT

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

invoice status

jvitantonio — Fri, 24 Feb 2012 10:20:15 GMT

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.

invoice status

CELAMBARASAN — Fri, 24 Feb 2012 10:22:33 GMT

Hi,

Cann't understand clearly little more briefer please.

Celambarasan

Re: invoice status

Fri, 24 Feb 2012 11:05:28 GMT

hi,

plz find the attached sample qvw.

Thanks in Advance.

invoice status

jvitantonio — Fri, 24 Feb 2012 11:13:11 GMT

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

invoice status

CELAMBARASAN — Fri, 24 Feb 2012 11:21:08 GMT

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