Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tomcatxx
Creator
Creator

Pivot Table expression

Hi, there. I want to make a pivot table like that. There are only 2 dimensions 'Minifabrik' and 'Day'.

MinifabrikDayWeThFrAvgTarget
MF1%%%%%
MF2%%%%%
MF3%%%%%
MF4%%%%%

I made a table but not finished.

3.PNG

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)

Thank you.

data source

Load  Minifabrik,

          Day,

          A,

          B,

          T

From xx.qvd

12 Replies
neelamsaroha157
Specialist II
Specialist II

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.

tomcatxx
Creator
Creator
Author

Oh, I'm sorry. It's here.  Pivot Avg() .Help!

tomcatxx
Creator
Creator
Author

Thank you. It's a test. Pivot Avg() .Help!