Discussion Board for collaboration related to Creating Analytics for QlikView.
I need a solution for my problem. I want to use the totals of the tables below for further calculations.
There must be a solution, but I couldn't find it. I tried AGGR, sum(total <field>), but without result.
Order 960 has 5 codes of 30 and order 961 has 1 code of 30.
I need the following figures:
- Total Orderbedrag = 180
- Avg Orderbedrag = 90
- Avg Bonbedrag = 30
Can you help me with this?
Can you share your sample data please?
Can you share a sample app with small data?
Hi Manish and Shyamal,
This comes from my DB, so I do not have sample data. Or can I export this to excel?
Just give us few lines in excel...
I will add two xls files. Kind regards, Erwin
SUM(TOTAL [Order Amount])/COUNT(TOTAL DISTINCT OrderId)
SUM([Order Amount])/COUNT(DISTINCT OrderId)
Dont have idea about
Avg Bonbedrag = 30
This does not seem to work.
below the results of your expressions:
What is the dimension you are using?
It doens't matter if I use orderId or codeId.
the sum total stays the same.