topic Matching string and returning field value in text object in QlikView

Matching string and returning field value in text object

Soham — Sat, 16 Nov 2024 19:19:31 GMT

I have two tables -

eg -

T1 T2

T1F1 T1F2 | T2F1 T2F2

abcd 65 | xyz 10002
xyz 100 | efg 10029
lpq 19 | mno 10078

I want to show value of T2F2 for T2F1 = xyz . Ideally I need to get T1F1 with highest T1F2 value and show T2F2 for the same value in a text and image object. For simplicity let's hard code the value 'xyz'

I have tried

=if(min([T2F1] like 'XYZ'),'Y','N')

from a different post which returns Y but when I replace 'Y' with the field name nothing gets returned.

=if(min([T2F1] like 'XYZ'),T2F2,'N')

The table T2F2 contains unique values for T2F1.

Would appreciate any help as I am a newbie to qliksense.

Thanks.

Re: Matching string and returning field value in text object

martinpohl — Fri, 10 Jan 2020 14:09:37 GMT

I don't know what the reason is but see attached.

Regards

Re: Matching string and returning field value in text object

Soham — Fri, 10 Jan 2020 14:15:54 GMT

I am sorry about this. I open the .qvw file but I don't see anything. Can you please guide me to what I should be looking for ?

Re: Matching string and returning field value in text object

martinpohl — Fri, 10 Jan 2020 14:20:57 GMT

here is a screenshot, hope you can see

Re: Matching string and returning field value in text object

Taoufiq_Zarra — Fri, 10 Jan 2020 14:24:05 GMT

Honestly, I don't get it

but I think this will help you

first in the script :

T1: LOAD T1F1 as Key,* INLINE [ T1F1,T1F2 abcd,65 xyz,100 lpq,19 ]; T2: LOAD T2F1 as Key,* INLINE [ T2F1,T2F2 xyz,10002 efg,10029 mno,10078 ]; LOAD FirstSortedValue(T1F1,-(T1F2)) as MaxT1F_ Resident T1 ; LET vMaxT1F1 =peek('MaxT1F_');

and then in the text/image object :

=only({<T2F1={$(vMaxT1F1)}> } T2F2)

Re: Matching string and returning field value in text object

Soham — Fri, 10 Jan 2020 14:24:40 GMT

Thank you for this. I do see it and it is working fine. But is there any reason as to why the if expression was not working ?

Re: Matching string and returning field value in text object

Taoufiq_Zarra — Fri, 10 Jan 2020 14:29:07 GMT

T2F1 is a string !

min(T2F1) ->minstring(T2F1)

but it's not good to use it like that also you must to aggregate ....

Re: Matching string and returning field value in text object

Soham — Fri, 10 Jan 2020 14:33:49 GMT

Thank you.