topic Re: Inline Table in QlikView

Inline Table

Anonymous — Wed, 17 Dec 2014 19:25:55 GMT

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

Re: Inline Table

german_avanzato — Wed, 17 Dec 2014 19:34:24 GMT

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.

Re: adding new column

maxgro — Wed, 17 Dec 2014 19:35:06 GMT

you can join the tables

// existing table

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

];

Re: Inline Table

Thu, 18 Dec 2014 04:52:48 GMT

Below link may help you ....

New to QlikView Videos

Re: Inline Table

amit_saini — Thu, 18 Dec 2014 05:01:21 GMT

Hi,

mentioned below is one example:

How to rename my Pie-Chart Values?

Thanks,

Re: Inline Table

saumyashah90 — Thu, 18 Dec 2014 05:13:16 GMT

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

Re: Inline Table

Anonymous — Thu, 18 Dec 2014 05:45:28 GMT

thankyou SaumyaShah its working

Thanks