topic Re: ApplyMap it is possible to add condition ? in QlikView

ApplyMap it is possible to add condition ?

paulyeo11 — Tue, 17 Jan 2017 09:11:25 GMT

Hi All

How to recode by mapping with condition ?

I have below script work fine , when SOURCE=Q_DOD_20167

ApplyMap('MapGroup',GROUP_CLASS,'OTHERS') as [GROUP_CLASS_]

So that i can achieve below :-

When SOURCE = Q_DOD_2016 , GROUP_CLASS = G1 , GROUP_CLASS_ = G1-GL ( Correct )

nOW When SOURCE = Q_FCKL09 , GROUP_CLASS = G1 , GROUP_CLASS_ = G1-GL ( Wrong )

hOW TO MAKE SOURCE = Q_FCKL09 , GROUP_CLASS = G1 , GROUP_CLASS_ = G1-KL ?

Hopw some one can advise me.

For testing my QVW , pls unzip the file and copy all the file to C:\TEMP

Paul

MK_QSL — Tue, 17 Jan 2017 09:16:51 GMT

Sorry to say but why you are not creating a simple example or sample document to work!

The current example requires lots of work for anyone to answer.

Better you create a sample excel file with only necessary fields for this question and upload it.

paulyeo11 — Tue, 17 Jan 2017 09:28:34 GMT

Hi Manish

You got the point. I think i should re-post again. Thank you for your feedback.

Paul Yeo

paulyeo11 — Tue, 17 Jan 2017 09:34:19 GMT

Hi Manish

I cannot further simply my sample doc. may be i should just enclosed the QVW.

Hope some one know the solution can share with me.

I also notice that most of the expert there , they don't even need to look at my simple doc and can suggest me the solution,

Paul