Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
tomcatxx
Creator
Creator

Pivot Avg() .Help!

Hi, there. I have a question about pivot table. I need a pivot table like that.

1.PNG

But I don't know how to write expression to get the last 2 columns. I made a test .qvw for u. Avg is average % value of days for MF. Target is a field which u can find in loaded table.

Help! Thank you very much.

regards

1 Solution

Accepted Solutions
sunny_talwar

8 Replies
qliksus
Specialist II
Specialist II

There are many ways of doing it a simple can be with adding a dummy dimension and using the below expression

Dim1 : '  '

Dim2 :  Region

Exp :  If ( isnull(columnno()) ,  Give your target expression here  ,

Avegrage expression here )

tomcatxx
Creator
Creator
Author

Can u upload .qvw? thank u.

balabhaskarqlik

May be try like this:

=Sum(Aggr(Avg(Day), Minifabrik))/Count(DISTINCT Day Minifabrik)

tomcatxx
Creator
Creator
Author

It doesn't work. thank u.

Anil_Babu_Samineni

Probably you need to share excel, That would spot. But, Here is the lucky way

Load * Inline [

Dim

1

2

3

];

Dimension

1) MF

2) Pick(Dim, 'Avg', 'Target')

Expression

Pick(Dim, (Sum(A)/Sum(B)), (Avg(A)/Avg(B)), ((Sum(TOTAL A)/Sum(TOTAL B))/(Count(TOTAL <A> A)/Count(TOTAL <B> B))))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
tomcatxx
Creator
Creator
Author

Thank you for ur post. But it looks like that. There is only average values.

2.PNG

What I want is like that, in which u can see all values. You don't need Excel because u can find it in qvw.

1.PNG

sunny_talwar

Check attached

Capture.PNG

tomcatxx
Creator
Creator
Author

Thank you very much. It is what I want.