Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I ended up using the peek function in the script to get each value.
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
May be try this:
=Only({<F1 = {'* b'}>}F2)
I ended up using the peek function in the script to get each value.