Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jorgelardi
Not applicable

Problems with fieldvalue

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

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: Problems with fieldvalue

Try this:

For stock on Jan 1st

FirstSortedValue(Stocks, Date)

For stock on Jan 31st

FirstSortedValue(Stocks, -Date)

5 Replies
sunny_talwar
Not applicable

Re: Problems with fieldvalue

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

jorgelardi
Not applicable

Re: Problems with fieldvalue

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

sunny_talwar
Not applicable

Re: Problems with fieldvalue

Try this:

For stock on Jan 1st

FirstSortedValue(Stocks, Date)

For stock on Jan 31st

FirstSortedValue(Stocks, -Date)

jorgelardi
Not applicable

Re: Problems with fieldvalue

Wonderful !!!

Thank you Sunny T

sunny_talwar
Not applicable

Re: Problems with fieldvalue

No problem, I am glad I was able to help