Subquery in Qlikview?

[narender123]

Hello Team,
Please tell me, How to handle this subquery in Qlikview?

select * from track t
where t.doc_ver =
(SELECT MAX (doc_ver)
FROM un_asybrk_track tr,ied i
WHERE tr.ied_id = i.ied_id )

Thanks,

Narender

[MayilVahanan]

HI 

You can use same query in Qlik itself. 

Or 

Load * from track.qvd(qvd);

Inner join

Load Id, Max(doc_ver) as doc_ver from un_asybrk_track.qvd(Qvd) group by Id;

[narender123]

Hi Mayil,
Thanks for your suggestion.

I did this at the script level.

mix:

load

MAX (doc_ver),ied
FROM un_asybrk_track tr group by ied;

inner join

load

ied
FROM ied ;

no concatenate

newmix:

Load * resident mix;

drop mix;

use this new mix table for join track table.

Thanks,

Narender

[QFabian]

Hi @narender123 , did you try with EXISTS() in your Where?, is a efficient way to do what you want.

https://help.qlik.com/en-US/sense/November2020/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecor...

[narender123]

Hi QFabian,

Thanks for your reply.

I used direct query in QlikView during qvd conversion because inner join option is showing wrong data.

After my report, I will try with Exit() and let you know.

Thanks.

Narender