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 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.