topic Re: trying to get a specific value in QlikView

trying to get a specific value

bbax1234 — Mon, 24 Oct 2016 19:36:20 GMT

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,

Re: trying to get a specific value

Oleg_Troyansky — Mon, 24 Oct 2016 20:15:09 GMT

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

Re: trying to get a specific value

sunny_talwar — Mon, 24 Oct 2016 20:15:44 GMT

May be try this:

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

Re: trying to get a specific value

bbax1234 — Thu, 27 Oct 2016 14:34:41 GMT

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