topic joins in QlikView

joins

vignesh_s — Wed, 25 Nov 2020 16:16:04 GMT

i have a table1 ,i want Max(NAV_ID) such that,say i have Date=1/11/12 Fundid=99,NAV_ID=2 and Date=1/11//12 fundid=99,NAV_ID=3

,i want to diaplay only the NAV_ID=3,Date=1/11//12 fundid=99 followe by other fields(A,B,C,D....) w.r.t to NAV_ID

i tried load resident to achive ths and i left joined with load table ,i did not got the result properly

table1:

load

Date, FundID, NAV_ID,A,B,C,D,E,F;

Anonymous — Tue, 26 Dec 2017 17:56:08 GMT

try

Load Date, FundID, A,B,C,D,E,F

max(NAV_ID)

group by Date, FundID, A,B,C,D,E,F

Anil_Babu_Samineni — Wed, 27 Dec 2017 02:22:52 GMT

I don't think where Max() won't work direct load. You could use something like Left / Right join to deserve

Table1:

Load Date, FundID, A,B,C,D,E,F From Table1;

Right Join (Table1)

Load Date, max(NAV_ID) Resident Table1 group by Date;

Anonymous — Wed, 27 Dec 2017 04:12:46 GMT

absolutely right your solution

vignesh_s — Wed, 27 Dec 2017 07:45:16 GMT

i used right join but ,whn i compare the result with xsl file the value is wrong

d_prashanthredd — Wed, 27 Dec 2017 09:38:53 GMT

Hi Vignesh,

What you compared and what is wrong in that?

Anil's solution gonna work fine and the sollution was to identify the max NAV_ID.

If you can specify the problem clearly, anyone can provide you the correct solution.

vignesh_s — Wed, 27 Dec 2017 09:42:09 GMT

tanks i got solution

Anil_Babu_Samineni — Wed, 27 Dec 2017 09:44:56 GMT

You need to understand the Decimal concept using Num()..