topic Re: Tables / Scripting in QlikView

Tables / Scripting

Thu, 22 Jan 2015 02:06:09 GMT

I have data which looks similar to this.

I need to take the "Freight" for a combination of "Plant", "Store" and "City" ("Vehicle" not required)

That "Freight" which has latest "Valid_from" and which is the Maximum in case of repetition.

For eg:

In the above scenario, for P1 - S1 - C1, there are 3 freights.

1st is valid from 01.Jan.2014 while 2nd and 3rd from 01.Jan.2015.

Among the last 2, there are 2 different Vehicles V1 and V2. I need to take the Maximum of the two .i.e., 75.

Any help is extremely appreciated.

Regards

Raghav

Gysbert_Wassenaar — Thu, 22 Jan 2015 10:47:07 GMT

See attached qvw

francoiscave — Thu, 22 Jan 2015 10:57:31 GMT

Hi Raghav,

See the attached file to get the solution.

Best Regards,

François

francoiscave — Thu, 22 Jan 2015 13:08:19 GMT

Hi Ragghav,

Have you find a solution ?

If your are satisfied by a response, please mark it as correct or helpful to close this tread.

If not, how can we help you?

Thanks,

François

Fri, 23 Jan 2015 18:34:48 GMT

Hi François,

Thanks for your reply. But I still am to access my system. Will reply as

soon as I check please.

Thanks again for your immediate response

Regards

Raghav