Linear table issue

[marikabi]

Hi all,

I ma trying to calculate the total number of channels in the network.

To explain better:

we have a lot of circuits ( [Circuit])  in our network with different capacity ([Bandwidth]). Each circuit is composed from a different number of channels. To understand how many channels, we use the dimension Bandwidth.

So I loaded a sort of translation table on Qlik, where there is the list of all the possible bandwidth with the number of channels.

When I am using the formula Sum(CHANNELS) it gives me back a wrong number.

For example, in the attached extract I should receive back as total 390, instead of 30.

Any idea/suggestion?

I would also remove the dimension Circuit from the table, It is just to better explain where is my issue.

Thanks in advance,

Cheers

[sasikanth · Accepted solution]

HI,

Try to Aggregate based on Your dimensions,

Sum(AGGR( SUM(CHANNELS),Circuit,Bandwidth)

[marikabi]

Hi Sasi,

it does work when I filter the month.

But if I don't filter it, in order to see the trend, the values are completely different (and wrong)

Thank you

[marikabi]

adding also the dimension date between the brackets, it seems it's working.

Thank you

[sasikanth]

Hi,

glad it helped

Cheers