Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Showing The Related Field For the max ID

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 NoName
450001Asım Akın
450002Şeyma Can
450003Ali Alkan
450004Özsev Ateş

Data Source 2
Ins NoTelex IDTelex Num
4500014500011AB1
4500012AB2
4500013AB3
4500024500021BC1
4500022BC2
4500034500031CD1
4500044500041DE1
4500042DE2

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 NoKişi AdıTelex Num
450001Asım AkınAB3
450002Şeyma CanBC2
450003Ali AlkanCD1
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

1 Solution

Accepted Solutions
llauses243
Contributor III

Re: Showing The Related Field For the max ID

Hi Seyma

This is my offer, pls see image attached

Here you can to compare recent you solution with mine

Good luck, Luis.

10 Replies

Showing The Related Field For the max ID

Hi,

   Create a straight table.

   Include Isn no, Name as dimension and

   Max(Telex_num) as Expresion.

Regards,

Kaushik Solanki

Not applicable

Showing The Related Field For the max ID

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.

Showing The Related Field For the max ID

Hi,

   Then use Maxstring(Telex_num)

   This will work.

Regards,

Kaushik Solanki

Not applicable

Showing The Related Field For the max ID

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..

Re: Showing The Related Field For the max ID

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

Not applicable

Showing The Related Field For the max ID

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)

Re: Showing The Related Field For the max ID

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

Not applicable

Re: Showing The Related Field For the max ID

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
Contributor III

Re: Showing The Related Field For the max ID

Hi Seyma

This is my offer, pls see image attached

Here you can to compare recent you solution with mine

Good luck, Luis.

Community Browser