Discussion Board for collaboration on QlikView Scripting.
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
Go to Solution.
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
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?
thankyou SaumyaShah its working