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]

Yes, but even that does not work. I get the error that is attached in the image. It still says <Run_Date> does not exist

Arif

[#3]

As you can see in the attached image, all the fields exist there

Arif

[#4]

Hi Arif,

that is weird. Would you mind to post your QVD file?

cheers

Florian

[#5]

Sure,

I have attached the qvw file. Kindly check it. Also if you go to slider, and see the sort tab, the expression is disabled. Could you please see why can't i sort the slider by expression

Thanks

Arif

file:///C:/Documents%20and%20Settings/uarif/Desktop/KP_Test.qvw

[#6]

Ohh sorry, how do i post a file here?

[#7]

HI Arif,

use the reply option (not fast reply!) and go to tab "Options". There is a dialog to upload a file.

cheers

Florian

[#8]

Okay thanks

Here you go

Arif

[#9]

Hi Arif,

I can't work with that one, as I don't have the ODBC connection to your source. I thought about the QVD file spoke about earlier.

cheers

Florian

[#10]

I thought it will have data when you load it into your QV because i had loaded the data into it. does it generate a seperate file for data? i can only see one file there which i uploaded. i thought it stores the data in the same file.

I used odbc to load the data first time, but i thought you wont need the odbc connection again. I thought we can just write a load script there to play with the data that is already in the file. Am i missing something?

and thanks a lot for giving me soo much help

Arif

[#11]

Hi Arif,

no, if you want to test a load script, you need a data connection which won't be working for me in this case. You can't do a regular load from a QVW file, only from QVDs.

Anyway I checked the field name in your script and saw it is all lower case. Although it is a Win system, QlikView works case sensitivie, so maybe you need to type "run_date" instead of "Run_Date".

cheers

Florian