Discussion board where members can get started with QlikView.
Hi, there. I want to make a pivot table like that. There are only 2 dimensions 'Minifabrik' and 'Day'.
I made a table but not finished.
Values for column We Th and Fr are Sum(A)/Sum(B).
Can u help me to write expression for column Avgerage and Target? Target = avg(T)
Use below formula for average
for target as u have mentioned
Thank u, but it doesn't work.
Can u you write Expression for that? And sometimes I have data for 7 days(Mo~So). In this table, the null value just will not be showed.
Ok, try the following
Avg(Sum(TOTAL <MF> A)/Sum(TOTAL <MF> B))
Would you be able to share some raw data or a sample app?
Yes, I made a test.
May be like this:
=Sum(Sales) / Count(DISTINCT Date)
Where is the test file? can you share it with us?