topic Re: Subquery in Qlikview? in App Development

Subquery in Qlikview?

narender123 — Wed, 02 Jun 2021 09:55:35 GMT

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

Re: Subquery in Qlikview?

MayilVahanan — Wed, 02 Jun 2021 10:38:12 GMT

You can use same query in Qlik itself.

Load * from track.qvd(qvd);

Inner join

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

Re: Subquery in Qlikview?

narender123 — Wed, 02 Jun 2021 14:05:55 GMT

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

Re: Subquery in Qlikview?

QFabian — Wed, 02 Jun 2021 14:22:21 GMT

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/InterRecordFunctions/Exists.htm

Re: Subquery in Qlikview?

narender123 — Wed, 23 Jun 2021 10:59:41 GMT

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