Calculation in a textbox

[#1]

Hi Community

I want to perform a calculation in a text box.

My data table looks liks this:

Category	Num of Items	Item Prices
A	5	100
B	3	200
C	2	50

I would like to get the following results:

textbox1 --->Total Costs A  500

textbox2 ---> Total Costs  B 600

textbox3 ---> Total Costs C 100

How is the syntax for the following pseudocode in QlikView?

= Num of Item * Item Prices where Category is A

= Num of Item * Item Prices where Category is B

= Num of Item * Item Prices where Category is C

[oknotsen]

Why not just make it a chart? A straight table to be exact?

[sunny_talwar]

May be like this:

1) Only({<Category = {'A'}>}Num of Item * Item Prices)

2) Only({<Category = {'B'}>}Num of Item * Item Prices)

3) Only({<Category = {'C'}>}Num of Item * Item Prices)

[ziadm]

Hi

I am not sure what are you trying to achieve but this is how its done using set analysis

in Each Text box your formula should be

= sum( {< Category = {A}>  } [Num of Items] * [Item Prices])

= sum( {< Category = {B}>  } [Num of Items] * [Item Prices])

= sum( {< Category = {C}>  } [Num of Items] * [Item Prices])