Discussion board where members can get started with QlikView.
is it possible to ignore the dimension into a calculated expression ?
What I'm trying is this:
Year Month Customer Sales %
2012 10 AAA 1500 12
The % is calculated as sales/total sales for year and month, ignoring the customer dimension
Sales represents the total sales per customer, on October 2012. Year and Month are selected values by list boxes. The dimension is CUSTOMER
Any help is reallu appreciated
Thanks in advance for your help
Go to Solution.
If you have a chart with dimensions Year, Month and Customer and an expression like sum(Sales), you can use sum(total <Customer> Sales) to sum the sales across the whole range of customers.
Use TOTAL to ignore the dimensions.
=Sum(TOTAL<Dim1, Dim2, ....> Sales) in this experssion only the Dim1, Dim2... are considered.
=Sum(Sales) / Sum(TOTAL<Dim1, Dim2, ....> Sales)
Thanks very much!!