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
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.
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
Below link may help you ....
New to QlikView Videos
mentioned below is one example:
How to rename my Pie-Chart Values?
Load * [
if(Field1='a' or Field2='h',1,0) as NewField
This is how you can put condition and make a new field for inline tables
thankyou SaumyaShah its working
Retrieving data ...