Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

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

Hi!

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

excel.bmp

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

1 Solution

Accepted Solutions
MVP
MVP

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

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  )

View solution in original post

1 Reply
MVP
MVP

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

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  )

View solution in original post