topic Re: Searching sums in QlikView

Searching sums

Tue, 17 Feb 2015 20:38:39 GMT

Greetings,

I would like to search sums. I have vouchers which have separate line amounts. I would like to be able to search by the amount of the voucher. This gives me the amounts that I can search, but I am not sure how to search them. =sum([LineAmount],[VoucherNumber])

I would ike to be able t search for vouchers between $100.00 and $500.00.

I have been trying to solve this for too long. Has anybody ever done this before?

Thanks,

Frank

Re: Searching sums

Anonymous — Tue, 17 Feb 2015 20:54:50 GMT

cud you share your app or data

Re: Searching sums

Tue, 17 Feb 2015 20:56:21 GMT

I am sorry. THere is too much data even if I pared it down.

Re: Searching sums

Wed, 18 Feb 2015 04:44:53 GMT

could you please upload a sample data.

Re: Searching sums

Wed, 18 Feb 2015 05:11:10 GMT

I guess, this is possible in script level.

If you want an expression in search object,first you have to calculate tat expression as a field in script part

Re: Searching sums

avinashelite — Wed, 18 Feb 2015 05:12:39 GMT

try like this:

Aggr(sum([LineAmount]),[VoucherNumber]) this will give the sum amount based in the voucher numbers.

Then you can search with the sum

Re: Searching sums

Wed, 18 Feb 2015 13:40:59 GMT

THis is getting closer to what I am looking for. This is the question that is being asked: Show me vcher totals between $100 and $1000.

Re: Searching sums

jyothish8807 — Wed, 18 Feb 2015 14:09:12 GMT

Hi Frank,

Try to create two variable Var1 and Var2, one for your lower limit of voucher and one for the upper limit.

In chart try to something like this:

if( [LineAmount] >= Var1 and [LineAmount]<=Var2, Aggr(sum([LineAmount]),[VoucherNumber]))

Hope it helps.

Regards

Re: Searching sums

Wed, 18 Feb 2015 16:25:19 GMT

(Sum([Check Amount])> NUM#(vLoStrat) and sum([Check Amount]) < NUM#(vHiStrat),sum([Check Amount]))

I was able to use this. Thank You KC!

Re: Searching sums

jyothish8807 — Wed, 18 Feb 2015 16:40:32 GMT

You are welcome