Hi

[#1]

Hi All,

I am new to Qlikview, could you please help me on this request?

Using set analysis how we can dynamically fetch the maximum value.

I used the following expression but which is not produce anything.

sum({1<[Shipping Fee]= {"$=(Max([Shipping Fee])"}>}[Order-Total])

[its_anandrjs]

Try this expression

sum({<[Shipping Fee]= {"$( =Max([Shipping Fee]) )"}>}[Order-Total])

Or

sum({1<[Shipping Fee]= {"$( =Max([Shipping Fee]) )"}>}[Order-Total])

And also you can try

sum({<[Shipping Fee]= {'$( =Max([Shipping Fee]) )'}>}[Order-Total])

Regards

Anand

[narband2778]

hi,

Change to

sum({1<[Shipping Fee]= {"$(=Max([Shipping Fee])"}>}[Order-Total])

HTH

KR,

Naresh

[Anonymous]

HI,

try:

sum({1<[Shipping Fee]= {"$( =Max([Shipping Fee]) )"}>}[Order-Total])

or

sum({<[Shipping Fee]= {"$( =Max([Shipping Fee]) )"}>}[Order-Total])

Regards

Neetha

[#5]

Hi Anand,

Thanks, I tried with this expression but still I faced same issue, no result.

[#6]

Thanks, I tried with this expression but still I faced same issue, no result.

[#7]

Thanks, I tried with this expression but still I faced same issue, no result.

[Anonymous]

Hi,

Please post sample data,So can help.

Regards

Neetha

[#9]

Customer-Name	Emp-id	Order-date	Order-Month	Ord-id	Order-Total	Ship-Date	Shipping Fee	Status	Tax
Company A	1000	12-Dec-12	2	44	2145.5	-	0	New	0
Company A	2000	13-Dec-12	1	56	1365.5	-	0	New	0
Company A	3000	14-Dec-12	3	45	2458	14-Jan-13	200	Closed	0
Company B	4000	15-Dec-12	5	76	0	15-Jan-13	200	New	0
Company B	5000	16-Dec-12	4	87	357	16-Jan-13	10	Closed	0
Company B	6000	17-Dec-12	6	54	200.5	17-Jan-13	10	New	0
Company C	7000	18-Dec-12	1	78		18-Jan-13	40	Closed	0
Company D	8000	19-Dec-12	3	89	0				0
Company D	9000	20-Dec-12	3	44	1452	20-Jan-13	10	Closed	0
Company E	10000	21-Dec-12	2	89					0
Company F	11000	22-Dec-12	4	67	2145	22-Jan-13	15	Closed	0
Company G	12000	23-Dec-12	5	45	365	23-Jan-13	15	New	0
Company H	13000	24-Dec-12	5	34	2145	24-Jan-13	45	New	0
Company I	14000	25-Dec-12	6	56					0
Company J	15000	26-Dec-12	6	78	200	26-Jan-13	200	Closed	0
Company K	16000	27-Dec-12	3	89	2415	27-Jan-13	200	Closed	0
Company L	17000	28-Dec-12	4	45	1200	28-Jan-13	100	New	0
Company M	18000	29-Dec-12	2	90	136	-	0	New	0
Company N	19000	30-Dec-12	1	89	0		4	Closed	0
Company X	20000	26-Dec-12	6	78	1000	26-Jan-13	200	Closed	0
Company Y	21000	27-Dec-12	3	89	2456	27-Jan-13	200	Closed	0
Company Z	22000	28-Dec-12	4	45	400	28-Jan-13	100	New	0
Company X	23000	29-Dec-12	2	90	150	-	0	New	0
Company Z	24000	30-Dec-12	1	89	0		4	Closed	0
Company X	25000	26-Dec-12	6	78	1000	26-Jan-13	200	Closed	0
Company Y	26000	27-Dec-12	3	89	2456	27-Jan-13	200	Closed	0
Company Z	27000	28-Dec-12	4	45	400	28-Jan-13	100	New	0
Company X	28000	29-Dec-12	2	90	150	-	0	New	0
Company Z	29000	30-Dec-12	1	89	0		4	Closed	0
Company Z	30000	30-Dec-12	1	89	0		4	Closed	0

[#10]

If I give this expression

sum({<[Shipping Fee]= {200}>}[Order-Total]) working fine.

Note: Shipping Fee = 200 is maxmum value in my data