topic Re: helpppppp pleas :( in QlikView

helpppppp pleas :(

Tue, 30 Jun 2015 13:40:40 GMT

hi freinds i have a table that i want to do some function on values of two columns and insert the result in a new column...

but i can't

this is my qvd file

Re: helpppppp pleas :(

jonathandienst — Tue, 30 Jun 2015 13:49:41 GMT

Qlik Community Tip: Posting Successful Discussion Threads

QlikCommunity Tip: How to get answers to your post?

Re: helpppppp pleas :(

Tue, 30 Jun 2015 17:37:27 GMT

Typical example

Table_Name:

Load

Column1,

Column2,

Pow(Column1,Column2) as x^y //Calculating x^y using Pow function

From Tab1.Qvd (qvd);

Note: I am answering this question from my personal laptop with QlikView personal edition. Couldn't open your QVW.

Regards,

KKR

Re: helpppppp pleas :(

maxgro — Tue, 30 Jun 2015 18:05:33 GMT

there are something to change in your script

I tried to change few lines at the beginning (bold)

try this and then let we know if there are problems or something to explain

let p=0;

eetemp:

LOAD AM,

ML,

NS,

p1,

p2,

p3,

nt,

mt,

FROM ee.qvd (qvd);

//if p1<> null then // p1 is a field with more values, you cannot check

if len(trim('aaa'))>0 then

LOAD

p1,p2,p3,

//p= (p1*1+p2*2+p3*3)/(p1+p2+p3);

(p1*1+p2*2+p3*3)/(p1+p2+p3) as p // this is a new calculated column

from ee.qvd (qvd); // you have to load from something (file, db, ....)

//end if // endif and ; at the end

endif;

Re: helpppppp pleas :(

Tue, 30 Jun 2015 20:18:46 GMT

thanks alot ....

my problem is how to use these statements in my edit Script's file... and where of my Script put these statement..

Re: helpppppp pleas :(

Tue, 30 Jun 2015 20:26:10 GMT

thanks my freind

i want to do some function on the values of two columns(for example:A,B) and insert the result into third columns (for example:c) in my table

i know that i should use 'for' or 'while'

and do my function in it

but i don't know where of my script should write these and how..

i read the structure of these command but i can't understand how and where use them...

Re: helpppppp pleas :(

Tue, 30 Jun 2015 20:35:10 GMT

excuseme have you an example about my problem that have if and while or for clause in that?

Re: helpppppp pleas :(

Wed, 01 Jul 2015 12:57:10 GMT

thanks i find it my self...