Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
bartvanwetten
Contributor

Multiply amount with minutes in pivot

Dear all,

Can someone help me out on this one:

How can I get the 'amountperhour' in the last column. It should be 760/345*60=132.17 for the second row in the pivot above.

QlikView document is attached.

Many thx!

Bart

1 Solution

Accepted Solutions

Re: Multiply amount with minutes in pivot

May be this

Amount/Num#(MinutesSpend)*60

View solution in original post

2 Replies

Re: Multiply amount with minutes in pivot

May be this

Amount/Num#(MinutesSpend)*60

View solution in original post

bartvanwetten
Contributor

Re: Multiply amount with minutes in pivot

Hi Sunny,

and again, you've made my day!

Bart