Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to not aggregate and show data in graph?

I want to see individual rows in graph. I want to see orders against clients but if a customer has two orders, show both in the graph. For example, If customer A has 25 orders on one date and 45 orders on another date, then I want to see a bar graph which shows orders against clients. However, I would want to see both orders (stacked/grouped) seperately in the graph rather than both aggregated against customer A

How can i do this

Arif

4 Replies
Not applicable
Author

Use the most detailed dimension(s) in the graph

Fabrice

alexandros17
Partner - Champion III
Partner - Champion III

Add as dimension order number

MK_QSL
MVP
MVP

Dimensions

Customer

Date or Month

Expression = SUM(OrderValue) or COUNT(Distinct OrderNumbers)

hic
Former Employee
Former Employee

All calculations in QlikView are aggregations. (Except calculated dimensions.)

So if you want one row per OrderID, you should have OrderID as dimension. See more on http://community.qlik.com/blogs/qlikviewdesignblog/2013/08/06/it-s-all-aggregations

HIC