Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I've got a bar chart with "Transaction Type" as a dimension, and Amount as an expression. I need to add another expression (a line chart on the right axis) which calculates the average number of transactions by customer number per Transaction Type. This is the expression I'm using:
avg( aggr( Count([Transaction Type]), [Customer Number]))
However, the line starts off with a high value and stops halfway through the transaction types while increasing (which is wrong of course). When I click on a particular transaction type, the line (now a dot) displays the correct value. Any solutions please?
Also - a customer can have multiple transactions, but I'm not sure if QlikView will take that into account in the avg() expression or whether It needs to be specified?
Any ideas?