Manipulate a field in existing data

[#1]

Hello,

I have loaded some data into qlikview. There is one field called run_date. I want to add one more column called my_month into the Qlikview table. This would be calculated as Month(Run_Date) as my_month.

Now my question is how do i perform this task using load statement. will the data be loaded again from database? . Do i have to include the rest of columns too in the load statement, or do i just need to include the renaming column, and i dont need to disturb the rest of data. I am new to Qlikview so kindly elaborate it simply

-br

Syed

[#2]

Thanks,

Is there any option while creating a project/report where i can specify so that it generates a qvd file instead of qvw file?

[#3]

Okay i got it

so qvw is generated if you load the data and then save the project. which is true in my case. so in this case, can i play with the data that has already been loaded? or is it only possible with qvd files?

Arif

[#4]

Hi Arif,

QVDs are pure data storage containers. For any data analysis, frontend design etc. you always have to work with QVW format.

Did you try the lower case alternative?

cheers

Florian

[#5]

yes, i did try to lower case and it is still not working .

I am still a bit confused. I have loaded data into my application and i want to add some more field to this table using its existing fields. I dont care if the field is added to the same table or i have to create another internal table, but is it possible in my case or not?

Can i just use the table name(which i can see in the table viewer and i also posted above) in the FROM clause rather than pointing to qvw or qvd files?

Arif

[#6]

Hi Arif,

maybe you should have a look at the Getting Started guide and documentation first because these are very very basic questions.

The SQL Statement is needed for the ODBC connection. You usually don't do data manipulation there except setting limits, maybe groupings. The Load statement should come before the SQL statement. There you do data manipulation and create new fields.

Example:

Load *,

Month(Run_Date) AS Run_Date_Month

SQL Select Field1, Field2, Field3 FROM sourcetable WHERE Field1 = Condition;#

cheers

Florian

[#7]

great,

This works when i use it just above the select statement and when i am actually bringing data from the database. I still got a lot to learn. I still don't know how can i add this new column using the data that has already been loaded.

However using the hint you just gave above, i can add this new field when there is a select statement below it and when the data is being fetched from the database

Thank you sooo much

Arif

[#8]

One more question . Do you know any reference guide or tutorial where i can read more about loading data , QVD and qvw files etc

Arif

[#9]

Hi Everybody,

Please help me, I am new in qlikview.and I want to insert the field as well as data.

This i want to insert

insert into zinch_qv_report_metadata

(

qv_object_id,

run_day_of_month,

run_today

)

values

(

'ch_incomplete_and_rejected_leads',

null,

1

);

now i have inserted the field but unable to insert data please help me..

Thanks i n Advance.

Message was edited by: sherbahadur

[#10]

Hi Everyone,

Please help me, I am trying to fire macro from the access point but macro is not working , in the server(production) macro is running but when I am trying to fire from the access point macro is not firing. I have downloaded IE pulgins also but still it is not working.

In server ----> security---> I have tick the Allow unsafe macro for execution on server and Allow macro for execution on server but still macro is firing from the server.

Thanks in Advance.

Sher Bahadur.