Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paulyeo11
Valued Contributor II

why the table name is durationMap12 ?

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

1 Solution

Accepted Solutions
prma7799
Honored Contributor III

Re: why the table name is durationMap12 ?

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

;

11 Replies
paulyeo11
Valued Contributor II

Re: why the table name is durationMap12 ?

my QVW

Re: why the table name is durationMap12 ?

I am not getting your question.

What are you expecting over there?

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


Regards

Great dreamer's dreams never fulfilled, they are always transcended.
paulyeo11
Valued Contributor II

Re: why the table name is durationMap12 ?

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 ?

yes.

Great dreamer's dreams never fulfilled, they are always transcended.
paulyeo11
Valued Contributor II

Re: why the table name is durationMap12 ?

Hi PM

my QVW file

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

Paul

prma7799
Honored Contributor III

Re: why the table name is durationMap12 ?

Hi Paul,

I am not able to open you file.

Thanks

paulyeo11
Valued Contributor II

Re: why the table name is durationMap12 ?

Hi Prashant

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

Paul Yeo

prma7799
Honored Contributor III

Re: why the table name is durationMap12 ?

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

;

paulyeo11
Valued Contributor II

Re: why the table name is durationMap12 ?

Hi P M

I don't understand what you mean ?

Paul

Community Browser