topic Re: Qlikview CASE statement or subquery inside a load and apply map in QlikView

Qlikview CASE statement or subquery inside a load and apply map

matthewp — Fri, 04 Sep 2015 08:51:12 GMT

Re: Qlikview CASE statement or subquery inside a load and apply map

petter — Fri, 04 Sep 2015 08:54:15 GMT

You can use If() for that purpose.

Re: Qlikview CASE statement or subquery inside a load and apply map

sasiparupudi1 — Fri, 04 Sep 2015 09:13:55 GMT

Try like this

t1:

load * Inline

[

PlaylistNo,Song ID,User

P36015,50434,JOHN

P39824,50434,LUKE

P41575,50434,MARK

P47775,50434,MATT

P50028,50434,MATT

];

Exemptsongs:

Load * Inline

[

Song ID

45875

65463

43785

90347

23456

89438

16745

50434

];

Exemptsongsmap:

Mapping LOAD

[Song ID],'Exempt' as [Song exempt]

Resident Exemptsongs;

ExemptUsermap:

mapping load * Inline

[

User,Exempt

MATT,1

];

NoConcatenate

final:

load PlaylistNo,[Song ID],if (ApplyMap('Exemptsongsmap',[Song ID],'NA')<>'NA' and ApplyMap('ExemptUsermap',User,'NA')=1,'Exempt','') as Exempt ,User resident t1;

DROP Table Exemptsongs,t1;

hth

Sasi

Re: Qlikview CASE statement or subquery inside a load and apply map

sasiparupudi1 — Fri, 04 Sep 2015 09:42:55 GMT

load PlaylistNo,[Song ID],if (ApplyMap('Exemptsongsmap',[Song ID],'NA')<>'NA' and ApplyMap('ExemptUsermap',User,'NA')=1,'Exempt','Non-exempt') as Exempt ,User resident usermap;

load PlaylistNo,[Song ID],if (ApplyMap('Exemptsongsmap',[Song ID],'NA')<>'NA' and ApplyMap('ExemptUsermap',User,'NA')=1,'Exempt','Non-exempt') as Exempt ,User resident YourtableName;

Re: Qlikview CASE statement or subquery inside a load and apply map

sasiparupudi1 — Fri, 04 Sep 2015 09:43:45 GMT

btw

did you include

ExemptUsermap:

mapping load * Inline

[

User,Exempt

MATT,1

];