Expression to sum the values on a bar chart

[#1]

Hi all,

I want to plot a bar chart, date as X axis and  sum of objects per date as Y-axis.. But, I would like to sum the objects of distinct dashboard names ..

I mean, on any date, if any dashboard is repeated, I would like to take the object count only once

can any one help me to do that?

I hope, I tried to explain the problem.. Please let me know, if any clarification needed

Thanks

[tresesco]

If a dashboard is having two different object amounts, which is to be summed? Or, if they occurs more than once they would have same object amounts?

[#3]

Hi Tresesco

Thanks for the reply

My apologies for the wrong data above, actually, dashboard has only one amount of objects..

No dashboard will not have different number of objects as they are identical..

[tresesco]

In that case, may be you can use : =Sum(Aggr(Agv(Objects), Dashboard))

[#5]

Hi Tresesco

AGv means do u mean Avg??

[tresesco]

Yes. That's a typo.

[#7]

Hi treseco,,

I used it, but I am getting wrong result..

[tresesco]

It is working with me - in sample data set. PFA

[#9]

May i ask you ?

why should we average ? i am getting the result in decimals.. number of objects should not be decimal in my app

Thanks

[Anil_Babu_Samineni · Accepted solution]

Can you let me know, How Objects associative in Qlikview object? Can you share the image for that?

Updated: (Try This)

=Sum(aggr( sum(Distinct objects),Dashboard))