Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table create additional measure for average

Hi,

I would like to show on my pivot table as below:

Formula:

Sales/trx = Nett / Trx

18.83 = 5086.69 / 270

But i not able to get this results, any idea?

Avg.PNG

Message was edited by: Bryant Law Here i attached my qvf file

1 Solution

Accepted Solutions
awhitfield
Partner - Champion
Partner - Champion

Here you go!

HTH Andy

View solution in original post

7 Replies
awhitfield
Partner - Champion
Partner - Champion

HI Bryant,

can you please upload your qvf?

Andy

Not applicable
Author

Hi Andy,

I did upload my qvf, check it out.

Bryant

awhitfield
Partner - Champion
Partner - Champion

Hi Bryant,

Change the Sales/Trx expression and the number format to as below as, and this is what you get you get this:

HTH Andy

Not applicable
Author

Dear Andy,

I still not able get it 18.84, could you upload your qvf.

Thanks.

Bryant

awhitfield
Partner - Champion
Partner - Champion

Here you go!

HTH Andy

Not applicable
Author

I didn't aware the expression can have more than 1 aggregation...

awhitfield
Partner - Champion
Partner - Champion

Excellent, glad it's sorted 

HTH Andy