topic Pivot table measure in App Development https://community.qlik.com/t5/App-Development/Pivot-table-measure/m-p/102580#M6868 <HTML><HEAD></HEAD><BODY><P>Here is a sample of my data</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 30.35pt; padding: 0 5.4pt 0 5.4pt;" width="357"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Dinosaur Type</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Dinosaur Name</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="115"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Century Named</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Saurischia</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Tyrannosaurus Rex</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="115"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1900</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Saurischia</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Allosaurus</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="115"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1800</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Ornithischia</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Triceratops</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="115"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1800</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Ornithischia</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Tyrannosauridae</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="115"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1800</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Ornithischia</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Hadrosauridae</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="115"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1800</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>I am trying to turn it into a pivot table like this</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 30.35pt; padding: 0 5.4pt 0 5.4pt;" width="235"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="107"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">Dinosaur Type</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1800</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1900</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="107"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">Ornithischia</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">75%</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">0%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="107"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">Saurischia</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">25%</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">100%</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>How do can I modify this expression as the measure in the pivot table to do that?</P><P style="margin-left: .5in;">([Dinosaur Type])/count(total <SPAN style="font-weight: inherit; font-style: inherit;">[Dinosaur Type])</SPAN></P></BODY></HTML> Tue, 03 Jul 2018 03:47:05 GMT leobrand 2018-07-03T03:47:05Z Pivot table measure https://community.qlik.com/t5/App-Development/Pivot-table-measure/m-p/102580#M6868 <HTML><HEAD></HEAD><BODY><P>Here is a sample of my data</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 30.35pt; padding: 0 5.4pt 0 5.4pt;" width="357"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Dinosaur Type</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Dinosaur Name</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="115"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Century Named</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Saurischia</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Tyrannosaurus Rex</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="115"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1900</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Saurischia</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Allosaurus</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="115"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1800</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Ornithischia</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Triceratops</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="115"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1800</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Ornithischia</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Tyrannosauridae</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="115"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1800</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Ornithischia</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="135"><P style="margin-bottom: .0001pt;"><SPAN style="color: black;">Hadrosauridae</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="115"><P align="right" style="margin-bottom: .0001pt; text-align: right;"><SPAN style="color: black;">1800</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>I am trying to turn it into a pivot table like this</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 30.35pt; padding: 0 5.4pt 0 5.4pt;" width="235"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="107"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">Dinosaur Type</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1800</SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">1900</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="107"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">Ornithischia</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">75%</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">0%</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="107"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">Saurischia</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">25%</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="64"><P align="center" style="margin-bottom: .0001pt; text-align: center;"><SPAN style="color: black;">100%</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>How do can I modify this expression as the measure in the pivot table to do that?</P><P style="margin-left: .5in;">([Dinosaur Type])/count(total <SPAN style="font-weight: inherit; font-style: inherit;">[Dinosaur Type])</SPAN></P></BODY></HTML> Tue, 03 Jul 2018 03:47:05 GMT https://community.qlik.com/t5/App-Development/Pivot-table-measure/m-p/102580#M6868 leobrand 2018-07-03T03:47:05Z Re: Pivot table measure https://community.qlik.com/t5/App-Development/Pivot-table-measure/m-p/102581#M6869 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please try this - </P><P>count([Dinosaur Type])/aggr(nodistinct count([Dinosaur Type]),[Century Named])</P><P></P><P>Thanks,</P><P>RT</P></BODY></HTML> Tue, 03 Jul 2018 05:14:59 GMT https://community.qlik.com/t5/App-Development/Pivot-table-measure/m-p/102581#M6869 Neymar_Jr 2018-07-03T05:14:59Z