topic Re: How to create a Column at scripting in QlikView

How to create a Column at scripting

kunkumnaveen — Thu, 02 Apr 2020 09:35:02 GMT

Hello All,

I am Trying something like below ,it is Possible to create a column with values CV,PV,ALL.

if(segment='COMMERCIAL','CV',
if(segment='PERSONAL','PV',
if(segment='COMMERCIAL' and segment='PERSONAL','ALL')

)) as SEGMENT

I know if we select both CV and PV which is nothing but ALL, ..but User specifically need CV,PV,ALL

Thanks

Re: How to create a Column at scripting

agigliotti — Thu, 02 Apr 2020 09:43:26 GMT

i think your expression below doesn't makes sense.

if(segment='COMMERCIAL' and segment='PERSONAL','ALL')

what does it means?

what are you trying to achieve?

Re: How to create a Column at scripting

kunkumnaveen — Thu, 02 Apr 2020 09:53:34 GMT

In a sample way, I have a Column Segment which has values COMMERCIAL,PERSONAL

Now what i am trying to create a derived column with name SEGMENT which should suppose to have CV,PV,ALL values

Which means

COMMERCIAL => 'CV',

PERSONAL => 'PV'.

COMMERCIAL+PERSONAL=>ALL

How to achieve this requirement

Re: How to create a Column at scripting

kunkumnaveen — Thu, 02 Apr 2020 11:20:55 GMT

Hi All,

Is my above requirement is feasible or Not

Re: How to create a Column at scripting

agigliotti — Thu, 02 Apr 2020 13:07:37 GMT

You could do this:

...
if( segment='COMMERCIAL', 'CV',
if( segment='PERSONAL', 'PV'
)) as SEGMENT;
...

New_Table:
LOAD * INLINE [
NEW_FIELD, SEGMENT
PV, PV
CV, CV
ALL, PV
ALL, CV
];

and use NEW_FIELD as your filter in UI.

Re: How to create a Column at scripting

kunkumnaveen — Fri, 03 Apr 2020 09:19:22 GMT

Hi,

Its worked , thanks for your suggestion.....