topic Choose Minimum Value OR Remove Max Value in QlikView

Choose Minimum Value OR Remove Max Value

Wed, 20 Jul 2011 11:11:13 GMT

Hi Guys,

I have a bit of a tough question....i think The reason this is difficult is that there are a few conditions that need to be satisfied before any manipulation can happen on my table. I have attached an example with some test data.

I don't expect anyone to be able to provide me with the full solution, but if you can point me in the right direction in terms of how I should approach this/functions to use, would be much appreciated

Regards,

Byron

Choose Minimum Value OR Remove Max Value

kaushiknsolanki — Wed, 20 Jul 2011 11:12:51 GMT

Hi,

There is no test file. Please upload it again.

Regards,

Kaushik Solanki

Choose Minimum Value OR Remove Max Value

Wed, 20 Jul 2011 11:13:45 GMT

Just uploaded, cheers

Choose Minimum Value OR Remove Max Value

Thu, 21 Jul 2011 08:19:29 GMT

A post to keep this active. Hopefully someone will take the time to assist me here.

Choose Minimum Value OR Remove Max Value

Fri, 22 Jul 2011 06:53:56 GMT

Another post to keep active

Re: Choose Minimum Value OR Remove Max Value

Fri, 22 Jul 2011 08:49:42 GMT

Hi,

As you requested the attached sample is going to help you giving a direction rather than complete solution.

Try to use peek or previous functions, try to add flags, try to do group by and all in the load script to achieve your requirement.

Please see the attached, where in i can see the scenario 1 and 2 are almost achieved.

Cheers.

Choose Minimum Value OR Remove Max Value

Fri, 22 Jul 2011 08:58:33 GMT

Hi BlackRockS

Still going through your reply but this looks fantastic. U put a lot of effort in and I appreciate that

Thank you very much
Byron

Re: Choose Minimum Value OR Remove Max Value

Fri, 22 Jul 2011 09:46:57 GMT

Good it helped you for the time i spent.

Cheers.