Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use the most detailed dimension(s) in the graph
Fabrice
Add as dimension order number
Dimensions
Customer
Date or Month
Expression = SUM(OrderValue) or COUNT(Distinct OrderNumbers)
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