Discussion board where members can get started with QlikView.
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
Date, FundID, NAV_ID,A,B,C,D,E,F;
I don't think where Max() won't work direct load. You could use something like Left / Right join to deserve
Load Date, FundID, A,B,C,D,E,F From Table1;
Right Join (Table1)
Load Date, max(NAV_ID) Resident Table1 group by Date;
absolutely right your solution
i used right join but ,whn i compare the result with xsl file the value is wrong
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.
tanks i got solution
You need to understand the Decimal concept using Num()..