Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

rgvavihs
Valued Contributor

Inline Table

     Hi i am new to qlikview

How to make operations like adding new column names by writing conditional statements on existeing fields in the same table by inline

1 Solution

Accepted Solutions
saumyashah90
Valued Contributor

Re: Inline Table

Hi rgv,

Table1:

Load * [

Field1,Field2,Field3

a,b,c

d,e,f

g,h,i

j,k,l

];

Table2:

Load

Field1,

Field2,

Field3,

if(Field1='a' or Field2='h',1,0) as NewField

Resident Table1;

This is how you can put condition and make a new field for inline tables

6 Replies
german_avanzato
Contributor

Re: Inline Table

If you have the code, just hit the hammer

And complete the wizard with the new column data.

Or, just put a "," to the last field name and complete the data.

MVP
MVP

Re: adding new column

you can join the tables

// existing table

a:

load rowno() as text1, 'new' & rowno() as newcolumn autogenerate 5;

// inline table

right join (a)

load * inline [

text1 ,text2, number1, number2, number3

1     ,   b ,         1,            2 ,          3

2     ,   d ,         4 ,           6  ,         5

12     ,   f ,          7 ,           8  ,         9

];

Not applicable

Re: Inline Table

Below link may help you ....

New to QlikView Videos

amit_saini
Honored Contributor III

Re: Inline Table

Hi,

mentioned below is one example:

How to rename my Pie-Chart Values?

Thanks,

AS

saumyashah90
Valued Contributor

Re: Inline Table

Hi rgv,

Table1:

Load * [

Field1,Field2,Field3

a,b,c

d,e,f

g,h,i

j,k,l

];

Table2:

Load

Field1,

Field2,

Field3,

if(Field1='a' or Field2='h',1,0) as NewField

Resident Table1;

This is how you can put condition and make a new field for inline tables

rgvavihs
Valued Contributor

Re: Inline Table

thankyou SaumyaShah its working          

Thanks

Community Browser