topic Re: Problems with fieldvalue in QlikView

Problems with fieldvalue

jorgelardi — Mon, 07 Mar 2016 18:32:16 GMT

Hi,

Fieldvalue ('Field', n) where n is the number of the row but the number of occurrence of that value without repetition.

Question: How can I identify the value of a field in a row number specific recital repetitions?

Thanks

Re: Problems with fieldvalue

sunny_talwar — Mon, 07 Mar 2016 18:51:46 GMT

Not sure I understand your question. Would you be able to elaborate?

Re: Problems with fieldvalue

jorgelardi — Mon, 07 Mar 2016 20:07:35 GMT

Example:

Date - Stocks

1/1/2016 - 56

2/1/2016 - 58

3/1/2016 - 58

4/1/2016 - 54

5/1/2016 - 54

.......

31/1/2016 - 58

I want to build two text object that, when I select the month of January in a list box in one of them I show the stock of day 1 and another of them show me the stock of the day 31.

I tried to resolve it with fieldvalue but the problem is that the stock of day 2 coincides with the day 3 and day 31.

So I want to try to solve it with fieldvalue or other resource

Thank you

Re: Problems with fieldvalue

sunny_talwar — Mon, 07 Mar 2016 20:56:38 GMT

Try this:

For stock on Jan 1st

FirstSortedValue(Stocks, Date)

For stock on Jan 31st

FirstSortedValue(Stocks, -Date)

Re: Problems with fieldvalue

jorgelardi — Mon, 07 Mar 2016 21:35:32 GMT

Wonderful !!!

Thank you Sunny T

Re: Problems with fieldvalue

sunny_talwar — Mon, 07 Mar 2016 21:43:43 GMT

No problem, I am glad I was able to help