topic Re: How obtain a value in QlikView

How obtain a value

Thu, 03 Nov 2016 18:37:44 GMT

Hi, i have problem for obtain a value.

I obtain the value Real AC. I do this with max(Real AC) = 99.37% and it works well but i need obtain the value Ppto AC = 99.98% and i don't know do this.

I am work into simple table..

Helps me please.

Re: How obtain a value

alexdataiq — Thu, 03 Nov 2016 19:38:16 GMT

It's not very clear to me what you want to achieve. Wouldn't a simple Max(Ppto AC) do the trick? Are you doing filter/selections based on Fecha?

If you could provide more details or maybe a sample application with your data it would be easier to assist you.

Regards

Re: How obtain a value

sunny_talwar — Thu, 03 Nov 2016 19:45:45 GMT

May be this:

FirstSortedValue([Ppto AC], -[Real AC])

Update: Removed the - sign next to Ppto AC based on Alejandro's response

Re: How obtain a value

alexdataiq — Thu, 03 Nov 2016 19:53:00 GMT

That is neat! Why is the minus sign needed in the first parameter? Wouldn't that return a negative value?

Regards

Re: How obtain a value

sunny_talwar — Thu, 03 Nov 2016 19:53:19 GMT

My bad, that is a typo

Re: How obtain a value

Thu, 03 Nov 2016 20:07:12 GMT

Thanks for you answer.

But if i write max(Ppto AC), I view 100% always and this is wrong.

The dimension of the table is the proyect, i need know the advance of proyect. This is la view i need:

real advance vs advance budget

p1 Advance constProy(P) = 99.98% (the budget must be equivalent to real progress)

Thanks!

Re: How obtain a value

Fri, 04 Nov 2016 15:39:31 GMT

Perfect. Thank you very much!!