topic Multiply string data in QlikView

Multiply string data

Tue, 20 Dec 2011 06:31:52 GMT

I have a field with values like "25 X 12". I want to create expression where I multiply these 2 values and get result. For e.g. 25 X 12 = 300

How do I do that?

vijay_iitkgp — Tue, 20 Dec 2011 06:41:44 GMT

Hi anu,

You can use the transformation in script as:

Num(Subfield(Field,'*',1)) * Num(Subfield(Field,'*',2)) AS Field2.

It will calculate value.

Regards

VIjay

Tue, 20 Dec 2011 06:44:41 GMT

Hi Vijay

Thanks for your quick reply.

But how can i do it at expression level?

vijay_iitkgp — Tue, 20 Dec 2011 06:47:35 GMT

Same expression you can use in Expression.

Can you please explain what should be your output table/chart .

Regards

VIjay

Tue, 20 Dec 2011 06:49:20 GMT

Report should have

Item Code

Item Size.

Item size will be 300(multiplication of 25 X 12)

vijay_iitkgp — Tue, 20 Dec 2011 06:55:03 GMT

Here you can do two things :

1. Create a field ItemSize in Script as I suggested earlier and use that field in you report.

2. You can use expression = (Num(Subfield(Field,'*',1)) * Num(Subfield(Field,'*',2))) in your expression tab.

Regards

VIjay

Tue, 20 Dec 2011 07:19:20 GMT

yes. tried this but not working

vijay_iitkgp — Tue, 20 Dec 2011 07:43:01 GMT

Itemcode	Dimension	=SubField(Dimension,'',1)SubField(Dimension,'*',2)
1	25*12	300
2	15*10	150
3	20*30	600
4	15*35	525
5	10*50	500

This is what I am getting by using the formula in pivote table with help of excel

Tue, 20 Dec 2011 08:22:41 GMT

gr8. Thanks for detailed response. Yes. I got it working...