How to calculate % divided by total in pivot and set analysis

[#1]

Hi!

I want to calculate % of ordercount/Total. I am getting wrong % in Qlikview Please Help

I try funtion in "% de Asignación"

=sum( {$<recd_tramo ={'1','2'}  >}  recd_deuda_total)

/

sum(TOTAL  < recd_ccc_ajustado >{$<recd_tramo ={'1','2'}  >}  recd_deuda_total  )

Add .qvw

Thanks!!

[swuehl · Accepted solution]

I think you need Date in your TOTAL qualifier field list:

=sum( {$<recd_tramo ={'1','2'}  >}  recd_deuda_total)

/

sum(TOTAL  < Date >{$<recd_tramo ={'1','2'}  >}  recd_deuda_total  )