topic Help for formula for calculating turnover on two dimensions associated with the same fact table in QlikView

Help for formula for calculating turnover on two dimensions associated with the same fact table

Anonymous — Wed, 12 Feb 2014 09:57:17 GMT

Hello to all.
I have the following data structure:

I must get the total turnover for AGE_ID and AGE_ID2 into two separate tables.

Estrvenstor is the table Data.

Table 1 Table2

AGE_ID Turnover AGE_ID2 Turnover

101 1.100 101 2.100

The two results should be obtained without the filter of the for AGE_ID influences the selection of the records of the second table which must be filtered for AGE_ID2.

Inizio modulo

It is possible to get it with the associative structure attached ?

In addition, the value assumed AGE_ID must then also be the value of filter for AGE_ID2.

Example.

AGE_ID = 101 (active filter)

Table 1

sum({<AGE_ID={"=$(=(AGE_ID))"},AGE_ID={"<>null"}>} total <AGE_ID> $(varFatturato))

I tried to use the following formula but it does not work!

For table 2 that formula should I use ?

Thanks for all your help

Re: Help for formula for calculating turnover on two dimensions associated with the same fact table

whiteline — Wed, 12 Feb 2014 10:53:23 GMT

Hi.

You can try to use P() function, for example:

sum({<AGE_ID=,AGE_ID2=P(AGE_ID)>} $(varFatturato))

Re: Help for formula for calculating turnover on two dimensions associated with the same fact table

Anonymous — Wed, 12 Feb 2014 14:44:03 GMT

Thank you for your council.

In selecting AGE_ID2, i also considered the filter for AGE_ID. The result is not correct. How do I do that?

In the calculation of the Table 2, i must take only the records that have AGE_ID2 = AGE_ID

Thanks