topic Re: Calculation in a textbox in QlikView

Calculation in a textbox

Wed, 25 Nov 2020 16:16:04 GMT

Hi Community

I want to perform a calculation in a text box.

My data table looks liks this:

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 — Tue, 31 May 2016 15:50:11 GMT

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

sunny_talwar — Tue, 31 May 2016 15:55:01 GMT

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 — Tue, 31 May 2016 16:00:54 GMT

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])