Showing The Related Field For the max ID

[#1]

Hello everyone,

I am new to qlikview development and I am stucked at this question , would appreciate your feedback,

I have two datasources ;

Data Souce 1
Ins No	Name
450001	Asım Akın
450002	Şeyma Can
450003	Ali Alkan
450004	Özsev Ateş

Data Source 2
Ins No	Telex ID	Telex Num
450001	4500011	AB1
	4500012	AB2
	4500013	AB3
450002	4500021	BC1
	4500022	BC2
450003	4500031	CD1
450004	4500041	DE1
	4500042	DE2

I need to create a table showing Ins No, Name, and Telex Num of the Max(TelexID) for that Ins No like in the table below,

Ins No	Kişi Adı	Telex Num
450001	Asım Akın	AB3
450002	Şeyma Can	BC2
450003	Ali Alkan	CD1
450004	Özsev Ateş	DE2

I could not get that Telex Num to the table chart. Can you show me how to do it?

Thank you

[kaushiknsolanki]

Hi,

   Create a straight table.

   Include Isn no, Name as dimension and

   Max(Telex_num) as Expresion.

Regards,

Kaushik Solanki

[#3]

Unfortunately Telex_Num is not in the number format, and I should find Telex Num of the Max(TelexID) like in the last table I wrote.

The answer does not work here.

[kaushiknsolanki]

Hi,

   Then use Maxstring(Telex_num)

   This will work.

Regards,

Kaushik Solanki

[#5]

Yes it works for the example I wrote, but in the database, TelexNum is not like AB1 but like 1SIG134398DTH and has no meaning at all, this is way i have to get the telexnum field via Max(Telex_ID)

is there any way for taking TelexNum via max(Telex_ID)  ??

Thank you for your quick answers by the way..

[kaushiknsolanki]

Hi,

   Make takes only the numeric values.

   So if you want to use the max you need to extract the no, from your field.

   But i would suggest that, if that field has no meaning, then try to avoid using this in your report.

   If you got the ans. pls mark this as answered.

Regards,

Kaushik Solanki

[#7]

Sorry, this is not what i am looking for,

because i am not sure if the maximum of TelexNum(numeric values) matches Telex_num of Max(telexID).

i should get the field via max(telexID)

[kaushiknsolanki]

Hi,

  Yes you can get the TelexID too using max.

  All depends on your requirement. What you want to show and what to not.

  If you dont have any other problem then Pls mark this as Answered.

Regards,

Kaushik Solanki

[#9]

I think you misunderstood me, thanks for your efforts though.

the expression below works on my Qv.

if(TelexID=max(Total<InsNo>TelexID),ONLY(TelexNum))

[llauses243 · Accepted solution]

Hi Seyma

This is my offer, pls see image attached

Here you can to compare recent you solution with mine

Good luck, Luis.