Discussion Board for collaboration related to QlikView App Development.
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)
You can use pick and match to get the one column for the avg and target instead of repeating it for everyday. And as Sunny said, it would be easier to understand once you provide the sample data.
Oh, I'm sorry. It's here. Pivot Avg() .Help!
Thank you. It's a test. Pivot Avg() .Help!