Multiplying 3 list boxes

[#1]

HI! I am new to qlikview and I have a little problem with multiplying in qlikview.I have 1 excel with 3 sheet.

in 1 sheet,

price of gameplay

500

600

700

800

in 2 sheet

number of game

1

2

3

4

5

6

in 3 sheet

total hour

1

2

3

4

5

I created those as listboxes.

I want to multiply these 3 and display as total in straight table.What should I do?

Thanks for your time.

[vivek_niti]

Hi,

First of all u cannot multiply 3 different fields from 3 different tables which are not linked to each other.

U have to get all the 3 fields in 1 table or link all the three tables and then u can multiply them at the front end.

Please see the attached file...

Hope it helps..

Regards,