topic Re: Show specific row-cell in a text box in App Development

Show specific row-cell in a text box

qlikwiz123 — Tue, 15 Oct 2024 15:12:04 GMT

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)

Re: Show specific row-cell in a text box

David_Friend — Tue, 15 Oct 2024 15:37:06 GMT

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

Re: Show specific row-cell in a text box

Kushal_Chawda — Tue, 15 Oct 2024 15:46:06 GMT

@qlikwiz123 use FieldValue function. see the details here

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

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

Re: Show specific row-cell in a text box

seanbruton — Tue, 15 Oct 2024 23:34:38 GMT

Kudos nice solution!!

Re: Show specific row-cell in a text box

qlikwiz123 — Mon, 21 Oct 2024 14:41:11 GMT

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!

Re: Show specific row-cell in a text box

Kushal_Chawda — Mon, 21 Oct 2024 15:24:20 GMT

@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');

Re: Show specific row-cell in a text box

Kushal_Chawda — Mon, 21 Oct 2024 15:36:55 GMT

@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)

Re: Show specific row-cell in a text box

qlikwiz123 — Tue, 22 Oct 2024 14:10:32 GMT

Great! Will look into these. Thank you!