topic Re: I need table on min and max input value in QlikView

I need table on min and max input value

Fri, 23 May 2014 04:49:07 GMT

HI!!

I have a table with the field in database or qvd is

employee code	name	hospital	bill_date	rate	qty	*amount(rateqty)**
1245	smith	xyz	01-Jan-14	400	1	400
1245	smith	xyz	15-Mar-14	500	1	500
1245	smith	xyz	20-Mar-14	500	2	1000

now i want to show above table on min and max value insert by user

I have taken two input box of varibale minAmt and maxAmt

let suppose value inputed by user is minAmt vaiable=500 and maxAmt=500

with the expresion : Sum({&<RATE={">=$(minAmt)<=&(maxAmt)"}>}Amount)

its working fine

but WHAT if my table is an accumulated table OR GROUP BY TABLE

i have tried LIKE THAT:

Sum({&<RATE={">=$(minAmt)<=&(maxAmt)"}>}SUM(Amount))

BUT IT IS NOT WORKING..

anbu1984 — Fri, 23 May 2014 05:13:59 GMT

You can use the same expression Sum({&<RATE={">=$(minAmt)<=&(maxAmt)"}>}Amount) for accumulated table.

Fri, 23 May 2014 08:38:54 GMT

try:

Sum({<rate={">=$(=minAmt)<=$(=maxAmt)"}>}rate*qty)

Field names are case sensitive!

If field amount is calculated during reload, you may of course try also:

Sum({<rate={">=$(=minAmt)<=$(=maxAmt)"}>}amount)

reg,

Fri, 23 May 2014 10:41:43 GMT

thnks for advice guys

but I dont want to search on amount now.....

I want to search on sum(amount)

suppose min value -=1500 and max value=1500

then it show only one row

1245

smith

xyz

Mar

500

1500

Mon, 26 May 2014 05:30:56 GMT

I got the desire result...... actually I was applying the expression on rate it should be on amount

wrong: Sum({<rate={">=$(=minAmt)<=$(=maxAmt)"}>}amount)

right: Sum({<amount={">=$(=minAmt)<=$(=maxAmt)"}>}amount)

thnks all for who replied...