topic Re: Hi in QlikView

Hi

Mon, 22 Dec 2014 15:13:10 GMT

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])

Re: Hi

its_anandrjs — Mon, 22 Dec 2014 15:19:48 GMT

Try this expression

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

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

And also you can try

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

Regards

Anand

Re: Hi

narband2778 — Mon, 22 Dec 2014 15:19:56 GMT

hi,

Change to

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

HTH

KR,

Naresh

Re: Hi

Anonymous — Mon, 22 Dec 2014 15:24:32 GMT

HI,

try:

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

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

Regards

Neetha

Re: Hi

Mon, 22 Dec 2014 16:03:24 GMT

Hi Anand,

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

Re: Hi

Mon, 22 Dec 2014 16:08:12 GMT

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

Re: Hi

Mon, 22 Dec 2014 16:08:19 GMT

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

Re: Hi

Anonymous — Mon, 22 Dec 2014 16:11:13 GMT

Hi,

Please post sample data,So can help.

Regards

Neetha

Re: Hi

Mon, 22 Dec 2014 16:15:01 GMT

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

Re: Hi

Mon, 22 Dec 2014 16:23:31 GMT

If I give this expression

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

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

Re: Hi

Mon, 22 Dec 2014 16:26:20 GMT

Please refer the sample data

Re: Hi

Mon, 22 Dec 2014 16:29:53 GMT

If I give this expression

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

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

On Mon, Dec 22, 2014 at 8:50 PM, Anand Chouhan <qcwebmaster@qlikview.com>

Re: Hi

Mon, 22 Dec 2014 16:31:24 GMT

If I give this expression

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

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

Re: Hi

its_anandrjs — Mon, 22 Dec 2014 16:59:05 GMT

Try this expression

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

It is worked at my end.

Regards

Anand

Re: Hi

narband2778 — Mon, 22 Dec 2014 17:08:02 GMT

hi,

PFA QV Document.

KR,

Naresh

Re: Hi

Mon, 22 Dec 2014 17:25:15 GMT

Hi Satheesh,

Please try this below expression. I hope its help for you.

=Sum({<Shipping={$(=Max(Shipping))}>}[Order-Total])

Regards,

@Sub2u

Re: Hi

Mon, 22 Dec 2014 18:58:34 GMT

This expression is working fine- Thanks

Re: Hi

Anonymous — Mon, 22 Dec 2014 19:03:51 GMT

So the issue is resolved now!!!