Inline Table

[Anonymous]

     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

[german_avanzato]

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.

[maxgro]

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

];

[#4]

Below link may help you ....

New to QlikView Videos

[amit_saini]

Hi,

mentioned below is one example:

How to rename my Pie-Chart Values?

Thanks,

AS

[saumyashah90 · Accepted solution]

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

[Anonymous]

thankyou SaumyaShah its working          

Thanks