topic multipy 2 fields from straight table in QlikView

multipy 2 fields from straight table

Wed, 23 Nov 2011 06:30:13 GMT

Hi all,

How can i multiply two fields in straight table Expression. The below is my data table structure.

A,B

1,10

2,20

3,30

In straight table , it should show like below

A, B, A*B

1,10,10

2,20,40

3,30,90

Thanks in advance

Regards

Venkat

rohit214 — Wed, 23 Nov 2011 06:36:39 GMT

hi satish

try this in your expression

column(1)*column(2)

may it helps you

thanks

rohit

Wed, 23 Nov 2011 06:44:37 GMT

Hi thanks for your reply,

Instead of Column(1) * Column(2) , can't i place A*B.

In straight table, added dimensions are A,B.

And in Expressions should multiply A*B.

How can i do this ?

Regards

Venkat

rohit214 — Wed, 23 Nov 2011 06:52:15 GMT

hi venkat

u can do that also

please find the attachment

thanks

rohit