Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
marikabi
Creator
Creator

Linear table issue

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

1 Solution

Accepted Solutions
sasikanth
Master
Master

HI,

Try to Aggregate based on Your dimensions,

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

View solution in original post

4 Replies
sasikanth
Master
Master

HI,

Try to Aggregate based on Your dimensions,

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

View solution in original post

marikabi
Creator
Creator
Author

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
Creator
Creator
Author

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

Thank you

sasikanth
Master
Master

Hi,

glad it helped

Cheers