Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vmsistemi
Partner
Partner

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

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

2 Replies
whiteline
Master II
Master II

Hi.

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

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

vmsistemi
Partner
Partner
Author

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