topic Re: Using total value within an expression in QlikView

Using total value within an expression

Tue, 31 Mar 2015 11:30:32 GMT

Hi everyone,

I am wondering, I have the following expression:

sum({<ORDER_TYPE = {'ORDER'}, DOCUMENT = {'BILL'}>} sales)

Now we set filters to a single brand and a single salesperson to generate reports for them. Problem is, in the expression above I want all those setting to be for the correct filters, except I want this expression to show all salespersons. I can't deselect the salesperson, since we have more reports.

I was thinking in the order of: sum({<ORDER_TYPE = {'ORDER'}, DOCUMENT = {'BILL'}, SALESPERSON = {1} >} sales)

But this obviously doesn't work. If we use sum({<ORDER_TYPE = {'ORDER'}, DOCUMENT = {'BILL'}, SALESPERSON = {*} >} sales) I still find problems, since it shows only the articles sold for the selected salesperson, not all in total.

Who can help?

Re: Using total value within an expression

Tue, 31 Mar 2015 11:34:59 GMT

hi maartena

can you share your file?

Re: Using total value within an expression

Tue, 31 Mar 2015 11:37:06 GMT

Unfortunately not. But the expression isn't rocket science . Do you have any ideas?

Re: Using total value within an expression

Tue, 31 Mar 2015 11:38:08 GMT

Hi,

You can try this expression.

sum({<ORDER_TYPE = {'ORDER'}, DOCUMENT = {'BILL'}, SALESPERSON = >} sales)

Re: Using total value within an expression

anbu1984 — Tue, 31 Mar 2015 11:39:48 GMT

To ignore selected salesperson, try this

sum({<ORDER_TYPE = {'ORDER'}, DOCUMENT = {'BILL'}, SALESPERSON = >} sales)

Re: Using total value within an expression

Tue, 31 Mar 2015 11:47:17 GMT

hii

try this expression

Sum({<order_type={'order'},document={'bill'},salesperson= >}sale)

Re: Using total value within an expression

sunny_talwar — Tue, 31 Mar 2015 11:54:12 GMT

Worth giving a shot:

=Sum({<ORDER_TYPE = {'ORDER'}, DOCUMENT = {'BILL'}, SALESPERSON = p(SALESPERSON) >} sales)

Best,

Sunny

Re: Using total value within an expression

avinashelite — Tue, 31 Mar 2015 11:56:22 GMT

try like this

sum({<ORDER_TYPE = {'ORDER'}, DOCUMENT = {'BILL'}, SALESPERSON = >} sales)

Re: Using total value within an expression

Tue, 31 Mar 2015 11:59:02 GMT

Thanks for all the 5 answers, but they don't do anything else then the one I already posted....

Re: Using total value within an expression

sunny_talwar — Tue, 31 Mar 2015 12:01:24 GMT

Maarten what exactly are you trying to achieve? You mentioned getting the total? would you be able to put some sample data down with your expected result? I think you need some kind of TOTAL if you are looking to get a total here or you also might have to consider alternate state depending on your chart's dimension (if it is SALESPERSON).

Without some sample input and output, this would be difficult to troubleshoot.

HTH

Best,

Sunny

Re: Using total value within an expression

avinashelite — Tue, 31 Mar 2015 12:03:50 GMT

please post your ...so that we can check it out