trying to get a specific value

[bbax1234]

Hi,

I have a table and I have arranged it in ascending order ( for first 3 values). now I need to get the specific values of each row/ column combination. I need to put the value of each element in a different text box eg Text box 1 value=team a,text box 2 value =team b and so on

for eg table is

F1	F2	F3	=sum(F4)
			134
team a	product a	region a	43
team b	product a	region b	45
team c	product c	region a	46

I tried using fieldvalue function but it is not giving me the expected answer. Please find the qvw attached.

I am getting product c where i should be getting product a and I am getting null when I should be getting product c. Any idea what I am doing wrong. Or is there any other function which I should use.

Regards,

BB

[Oleg_Troyansky]

Hi,

even if you sorted your table in a specific order, you can't rely on the FieldValue() function to return the expected results - depending on the number of duplicate values in each field, you may or may not get the desired result.

I'd suggest using Set Analysis to specify what element of the data you want to see in which text object.

cheers,

Oleg Troyansky

Learn advanced QlikView and Qlik Sense techniques in my book QlikView Your Business

[sunny_talwar]

May be try this:

=Only({<F1 = {'* b'}>}F2)

[bbax1234 · Accepted solution]

I ended up using the peek function in the script to get each value.