Discussion Board for collaboration related to Creating Analytics for QlikView.
I am new to qlikview development and I am stucked at this question , would appreciate your feedback,
I have two datasources ;
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,
I could not get that Telex Num to the table chart. Can you show me how to do it?
Go to Solution.
This is my offer, pls see image attached
Here you can to compare recent you solution with mine
Good luck, Luis.
Create a straight table.
Include Isn no, Name as dimension and
Max(Telex_num) as Expresion.
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.
Then use Maxstring(Telex_num)
This will work.
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..
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.
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)
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.
I think you misunderstood me, thanks for your efforts though.
the expression below works on my Qv.