topic Re: why the table name is durationMap12 ? in QlikView

why the table name is durationMap12 ?

paulyeo11 — Fri, 29 Dec 2017 08:59:13 GMT

Hi All

I have a QVW doc which is working fine,

I like to know why the table name is durationMap12 ?

Can some one share with me.

Paul

Re: why the table name is durationMap12 ?

paulyeo11 — Fri, 29 Dec 2017 08:59:44 GMT

my QVW

Re: why the table name is durationMap12 ?

PrashantSangle — Fri, 29 Dec 2017 09:18:05 GMT

I am not getting your question.

What are you expecting over there?

You are getting table name as durationMap12 because you name it.

Regards

Re: why the table name is durationMap12 ?

paulyeo11 — Fri, 29 Dec 2017 09:20:14 GMT

Hi Prashant

PM info me unable to open the QVW file i attach,

Can you let me know are you able to open it ?

Paul Yeo

Re: why the table name is durationMap12 ?

PrashantSangle — Fri, 29 Dec 2017 09:21:05 GMT

yes.

Re: why the table name is durationMap12 ?

paulyeo11 — Fri, 29 Dec 2017 09:21:45 GMT

Hi PM

my QVW file

Pls let me know are you able to open my file ?

Paul

Re: why the table name is durationMap12 ?

prma7799 — Fri, 29 Dec 2017 09:21:47 GMT

Hi Paul,

I am not able to open you file.

Thanks

Re: why the table name is durationMap12 ?

paulyeo11 — Fri, 29 Dec 2017 09:22:39 GMT

Hi Prashant

Do you mean you can open my QVW file which i first send ?

Paul Yeo

Re: why the table name is durationMap12 ?

prma7799 — Fri, 29 Dec 2017 09:26:27 GMT

Go to Duration tab and change your table name..

// Change name here..

LOAD *,

if(L_issue = '00/00/0000' AND L_move <> '00/00/0000', 'New Product'

,if(S1 > '0' AND S2 > '0' and S3 > '0', 'Fast Moving'

,if(L_issue = '00/00/0000' AND L_move = '00/00/0000', 'Not Order Yet'

,applyMap('durationMap', [No of Months_], '>72 Mth')

))) as Duration1

;

Re: why the table name is durationMap12 ?

paulyeo11 — Fri, 29 Dec 2017 09:28:34 GMT

Hi P M

I don't understand what you mean ?

Paul

Re: why the table name is durationMap12 ?

prma7799 — Fri, 29 Dec 2017 09:32:59 GMT

If you want to change your table name then simple change durationMap12 to your new table name.

Re: why the table name is durationMap12 ?

paulyeo11 — Fri, 29 Dec 2017 09:38:23 GMT

Hi P M

Okay now my question is , how to make this script into one table , so that it will not affect the other load script .

As i intend to put all the script you mentioned , at TAB = INVCSG

So that i can copy the whole script into my main QVW as per enclosed.

Paul Yeo