Pivot Avg() .Help!

[tomcatxx]

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

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

[qliksus]

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]

Can u upload .qvw? thank u.

[balabhaskarqlik]

May be try like this:

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

[tomcatxx]

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

[tomcatxx]

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

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.

[sunny_talwar · Accepted solution]

Check attached

[tomcatxx]

Thank you very much. It is what I want.