Expression as a dimension in bar chart

[rajpreeths]

I have two metrics like #orders and #customers. here I need to have a bar chart showing orders vs customers results.that is I want to know how many customers has ordered 1 order and how many customers have ordered two orders and how many three how many four and so on..could you please help me your inputs how to achieve this in Qlikview

[rubenmarin · Accepted solution]

Hi, maybe using a dimension like: =Aggr(Count(Distinct Order),Customer)

And Count(Distinct Order) as Expression