Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Issues with Full Accumulation

Hello

As per the attached images, Full Accumulation is not being properly done. Final total must be 403, but it is 383 (blue only).

If there had been missing values, it would have reflected in both graphs.

What might be the reason for this discrepancy?

Thanks in advance!

1 Solution

Accepted Solutions
Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand

View solution in original post

19 Replies
Gysbert_Wassenaar

Please post a small qlikview document that demonstrates this problem.


talk is cheap, supply exceeds demand
sunny_talwar

What is your expression what is the dimensions? Just looking at the image doesn't give us any information. Like Gysbert mentioned a sample to play around will be really helpful.

Best,

Sunny

kaveri_bhar123
Contributor II
Contributor II

Hi Kamil,

It appears to be issue in data model. Please post sample data.

Best regards,

Kaveri

Not applicable
Author

PS. Thank you for your concern. Yet, so sorry for such a late reply.

Not applicable
Author

Gysbert_Wassenaar

See attached example.


talk is cheap, supply exceeds demand

View solution in original post

Anonymous
Not applicable
Author

Is it possible to solve this problem just with the help of diagram functions?

I tried with above, rangesum, aggr... without success...

The problem is that you have to accumulate each color dimension separetely.

Any ideas?

Not applicable
Author

I tried that. Display looks fine. But then, filters do not apply i.e. particular chart is no more interactive

Anonymous
Not applicable
Author

that's why I asked for a solution using only diagram expressions...

(At the moment I have no idea how to solve it...)