Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
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
hi,
Change to
sum({1<[Shipping Fee]= {"$(=Max([Shipping Fee])"}>}[Order-Total])
HTH
KR,
Naresh
HI,
try:
sum({1<[Shipping Fee]= {"$( =Max([Shipping Fee]) )"}>}[Order-Total])
or
sum({<[Shipping Fee]= {"$( =Max([Shipping Fee]) )"}>}[Order-Total])
Regards
Neetha
Hi Anand,
Thanks, I tried with this expression but still I faced same issue, no result.
Thanks, I tried with this expression but still I faced same issue, no result.
Thanks, I tried with this expression but still I faced same issue, no result.
Hi,
Please post sample data,So can help.
Regards
Neetha
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 |
If I give this expression
sum({<[Shipping Fee]= {200}>}[Order-Total]) working fine.
Note: Shipping Fee = 200 is maxmum value in my data