Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Esteemed Contributor

Re: Pivot table create additional measure for average

Here you go!

HTH Andy

7 Replies
awhitfield
Esteemed Contributor

Re: Pivot table create additional measure for average

HI Bryant,

can you please upload your qvf?

Andy

Not applicable

Re: Pivot table create additional measure for average

Hi Andy,

I did upload my qvf, check it out.

Bryant

awhitfield
Esteemed Contributor

Re: Pivot table create additional measure for average

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

Re: Pivot table create additional measure for average

Dear Andy,

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

Thanks.

Bryant

awhitfield
Esteemed Contributor

Re: Pivot table create additional measure for average

Here you go!

HTH Andy

Not applicable

Re: Pivot table create additional measure for average

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

awhitfield
Esteemed Contributor

Re: Pivot table create additional measure for average

Excellent, glad it's sorted 

HTH Andy