topic chart that present different from the selection in QlikView

chart that present different from the selection

ester_pr — Wed, 03 Aug 2011 09:36:38 GMT

Hi,

I am trying to make a chart that when i choose invoce it will present all the sales fore that customer as if i choose customer and not invoc

i have trysd set that ignores invoice but it doesnt work

chart that present different from the selection

Wed, 03 Aug 2011 10:02:05 GMT

Hi ester_pr,

Not quite sure of your problem: is your chart currently displaying customer on one axis, and invoice value on another? Do you then want to display customers and sales (changing the expression: invoice value to sales value)?

is your chart by "Invoice Number" (and sales/invoices) and you want the dimension to change from "Invoice Number" to "Customer" ?

Can you post an example QV doc of your problem, and then I can have a play...?

Kind regards,

Rich

chart that present different from the selection

ester_pr — Wed, 03 Aug 2011 10:26:32 GMT

My chart displays, sum(sales) By month, the user is choosing in a list box -invoice number ,the chart sould display

all sales for the customer of that invoice in that month and prior

Kind regards,

Ester

Re: chart that present different from the selection

johnw — Wed, 03 Aug 2011 22:09:23 GMT

Perhaps this?

sum({<Invoice=,Customer=P()>} Sales)

chart that present different from the selection

ester_pr — Thu, 04 Aug 2011 05:51:29 GMT

Hi,

it sums all the Customers, I need only the Customer of the invoice

regards,

Ester

chart that present different from the selection

ester_pr — Thu, 04 Aug 2011 05:54:12 GMT

My mistake it does work

Thank you!!

Ester