topic Re: Sum after collapse in QlikView

Sum after collapse

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello Qliks,

I have the problem with creating expression. Below, you see 2 tables, first before a collapse Dim 1, and second after. How should look like expression to achieve an effect like in table 2?

Table 1:

DIM 1= Year
DIM 2= ACT	DIM2=FCT
1	2

Table 2 :

DIM 1

For the situation where DIM1 has two values in DIM2 (ACT and FCT), sum after collapse just these values where DIM2=ACT.

For the situation where DIM1 has one value in DIM2 (ACT ), sum after collapse just these values where DIM2=ACT.

For the situation where DIM1 has one value in DIM2 ( FCT), sum after collapse just these values where DIM2=FCT.

Regards

Jacek.

Re: Sum after collapse

Kushal_Chawda — Thu, 06 Jul 2017 11:10:37 GMT

Can you post some sample data with expected output?

Re: Sum after collapse

sunny_talwar — Thu, 06 Jul 2017 11:13:00 GMT

Would you be able to share some real data with the expectation of output from it?

Re: Sum after collapse

balar025 — Thu, 06 Jul 2017 11:23:31 GMT

Hi ,

You can use if(secondarydimensionality()=1,sum({<Dim2={'ACT'}>}Value))

Regards,

Ravi

Re: Sum after collapse

Anonymous — Thu, 06 Jul 2017 11:47:45 GMT

Hello,

It took some time :).

Regards

Jacek.

Re: Sum after collapse

sunny_talwar — Thu, 06 Jul 2017 11:49:02 GMT

Which object are we looking at? and what is the output required here?

Re: Sum after collapse

Anonymous — Thu, 06 Jul 2017 11:56:42 GMT

We have one variable for 3 tables $(vRevenue).

In Table 1 after collapsing Year-Month for month 2017-May(2017-Jun - similar situation), should we achieve : 109 852, not like now 247 151.

In Table 2 after collapsing Year-Month for month 2017-May(2017-Jun - similar situation), should we achieve : 109 852, not like now 247 151. The same effect because is one store in sample)

In Table 3 after collapsing Short Name, should we achieve : 2 689 038, not like now 2 966 337.

Regards

Jacek.