Show specific row-cell in a text box

[qlikwiz123]

I have a table as shown below.

Theme #	Theme	Summary
Theme 1	Customer	ABC
Theme 2	Service	ABC2
Theme 3	Shipping	XYZ
Theme 4	Tech	DFW
Theme 5	Policy	JFK

How do I show specific cell value in a text box? 

For example, how do I show 3rd value (Shipping) under 'Theme' in a text box? Similarly, if I only want to show 4th value under Summary in a text box (DFW)

[David_Friend]

@qlikwiz123 can you illustrate what you desire your outcome to be?

[Kushal_Chawda · Accepted solution]

@qlikwiz123  use FieldValue function. see the details here

=FieldValue ('Theme',3) -- 3rd value from Theme

=FieldValue ('Summary',4) -- 4th value from Summary

[seanbruton]

Kudos nice solution!!

[qlikwiz123]

Hi @Kushal_Chawda  Thank you! This works great. But I see a small issue. When the same value is repeating in a specific column more than once, this formula isn't working.

For example,

 FieldValue ('Summary',4) -- 4th value from Summary , which is 'DFW'. If the 6th value from Summary is also 'DFW', and I use FieldValue ('Summary',6), it comes up empty. Any solution to fix this? Thanks in advance!

[Kushal_Chawda]

@qlikwiz123  FieldValue always looks at distinct values of that field. If you want specific rows from data, there is no easy front end solution. You may need to create variables in script to load specific values at specific position

TableName:
Load * Inline [
Summary
ABC
ABC
ABC
XYZ
XYZ ];

let vSummary_1st_value = Peek('Summary',0,'TableName');
let vSummary_3rd_value = Peek('Summary',2,'TableName');

[Kushal_Chawda]

@qlikwiz123  This is front end solution. But this solution works only when you have primary key already present in your data

// 4th value
=Only({<Primary_Key={"$(=Aggr(If(RowNo(TOTAL) = 4, Primary_Key), Primary_Key))"}>} Summary)

//6th value
=Only({<Primary_Key={"$(=Aggr(If(RowNo(TOTAL) = 6, Primary_Key), Primary_Key))"}>} Summary)

[qlikwiz123]

Great! Will look into these. Thank you!