topic Conversion factor in QlikView

Conversion factor

Sun, 28 Oct 2012 10:51:31 GMT

Hi,

can anyone know about conversion factor.

I am having table with ProductID,ProductgroupID,Factorvalue.

I want to multiply this Factorvalue with productid.

How can i do this in qlikview.

any help..

Thanks,

baru

Re: Conversion factor

Gysbert_Wassenaar — Sun, 28 Oct 2012 10:57:44 GMT

If both ProductID and Factorvalue are numbers you can calculate the product of the two as a new field in the load script:

Load

ProductID,

ProductgroupID,

Factorvalue,

ProductID * Factorvalue as ProdFactVal

from ....etc;

In a chart you can do the same in an expression: =ProductID * Factorvalue. If the fields are strings you can use the num function to make numbers of them: =num(ProductID) * num(Factorvalue)

Re: Conversion factor

SunilChauhan — Sun, 28 Oct 2012 10:58:22 GMT

use below code

sum(ProductID*Factorvalue)

hope this helps

Re: Conversion factor

Sun, 28 Oct 2012 11:04:03 GMT

Hi SK C,

Thaks for reply,

I want to do dynamically,I want to write the logic in script level which means,the productId is linked to transaction table. so that in the future they will change the factovalue for that perticular productid it will efect to my reports with giving any calculation in reports.

I hope You understod,thank

baru

Re: Conversion factor

SunilChauhan — Sun, 28 Oct 2012 11:14:08 GMT

then better to go with suggestion above by Gysbert Wassenaar

Re: Conversion factor

Sun, 28 Oct 2012 12:11:28 GMT

can anybody help me in this....

regards,

baru

Re: Conversion factor

swuehl — Sun, 28 Oct 2012 13:12:40 GMT

Baru,

I think you already got some reasonable answers.

If these are not helping you, it would help us to understand if you add some informations. For example, try giving some sample lines of data describing your data model and your expected outcome (like a new field in the data model or a column in a chart (but then please describe also the dimensions you want to use).

You can add these informations for example as INLINE tables (QV script snippets using an LOAD * INLINE [.. ] format) or excel tables or at best a small QV .qvw file demonstrating your issue.