topic Showing The Related Field For the max ID in QlikView

Showing The Related Field For the max ID

Fri, 01 Jul 2011 08:24:24 GMT

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
450002	4500022	BC2
450003	4500031	CD1
450004	4500041	DE1
450004	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

Showing The Related Field For the max ID

kaushiknsolanki — Fri, 01 Jul 2011 08:38:43 GMT

Hi,

Create a straight table.

Include Isn no, Name as dimension and

Max(Telex_num) as Expresion.

Regards,

Kaushik Solanki

Showing The Related Field For the max ID

Fri, 01 Jul 2011 09:11:40 GMT

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

kaushiknsolanki — Fri, 01 Jul 2011 09:22:39 GMT

Hi,

Then use Maxstring(Telex_num)

This will work.

Regards,

Kaushik Solanki

Showing The Related Field For the max ID

Fri, 01 Jul 2011 09:36:32 GMT

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

kaushiknsolanki — Fri, 01 Jul 2011 09:41:13 GMT

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

Showing The Related Field For the max ID

Fri, 01 Jul 2011 10:00:02 GMT

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

kaushiknsolanki — Fri, 01 Jul 2011 10:19:09 GMT

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

Re: Showing The Related Field For the max ID

Fri, 01 Jul 2011 11:43:38 GMT

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

Re: Showing The Related Field For the max ID

llauses243 — Fri, 01 Jul 2011 13:18:35 GMT

Hi Seyma

This is my offer, pls see image attached

Here you can to compare recent you solution with mine

Good luck, Luis.

Re: Showing The Related Field For the max ID

Mon, 04 Jul 2011 05:49:24 GMT

Thank you, it is what i was looking for..