Getting the correct Total

[stevegimbrollmt]

Hi friends,

Not sure if this is an easy one, or if I am missing something stupid but I am trying to get proper total here which is definitely not 34,636,

Problem is that I am also dividing by 13 and obviously that figure is not correct,  There is the total function as an option but when you use a Bar Graph , you do not get that option to get the proper total. 

Thanks

[stevegimbrollmt]

That is why im so confused myself,  not sure If i can share a sample, il ltry but in the meantime im trying to figure this out .

Thanks for trying to help

[stevegimbrollmt · Accepted solution]

I did sort it out in the end.

What I realised was that the other figures where correct and that was becuase the WeekAsOf table and the Figures tables are directly linked while the Users Players was linked to the Figures Table. 

Although in theory it should have worked, I am assuming and will check further that Qlik is doing some selecting maybe some associated numbers for that total.. i don't know

but when I created a userid with a different name in the figures table and used that... it worked perfectly and robust.

So Im gona leave it to that for now..so thanks Sunny