topic Re: Linear table issue in QlikView

Linear table issue

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

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

Re: Linear table issue

sasikanth — Mon, 20 Feb 2017 09:48:38 GMT

HI,

Try to Aggregate based on Your dimensions,

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

Re: Linear table issue

marikabi — Mon, 20 Feb 2017 10:19:36 GMT

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

Re: Linear table issue

marikabi — Mon, 20 Feb 2017 10:21:48 GMT

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

Thank you

Re: Linear table issue

sasikanth — Mon, 20 Feb 2017 10:23:23 GMT

Hi,

glad it helped

Cheers