https://community.qlik.com/t5/App-Development/Different-dimensions-same-table/m-p/1523615#M37566 <P>add chart</P><P>Dimension:Product type</P><P>&nbsp;</P><P>=Count(&nbsp; {&lt;[Consumer Type]={'Guest'}&gt;}[Product Type])</P> Sun, 23 Dec 2018 08:58:47 GMT Channa 2018-12-23T08:58:47Z https://community.qlik.com/t5/App-Development/Different-dimensions-same-table/m-p/1523606#M37564 <P>This expression only works with one dimension.</P><P>Count({&lt;[Consumer Type]={'Guest'}&gt;}distinct[Product Type])</P><P>However I want to count the quantities of two different dimensions in the same table to look like this…</P><TABLE><TBODY><TR><TD><P>Priority Items</P></TD><TD><P>Quantity</P></TD></TR><TR><TD><P>Drink</P></TD><TD><P>7</P></TD></TR><TR><TD><P>Food</P></TD><TD><P>5</P></TD></TR><TR><TD><P>Cioppino</P></TD><TD><P>2</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>Here is my data</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P>Purch No</P></TD><TD><P>Consumer Type</P></TD><TD><P>Product Name</P></TD><TD><P>Product Type</P></TD></TR><TR><TD><P>00020</P></TD><TD><P>Employee</P></TD><TD><P>Negroni</P></TD><TD><P>Drink</P></TD></TR><TR><TD><P>00019</P></TD><TD><P>Guest</P></TD><TD><P>Daiquiri</P></TD><TD><P>Drink</P></TD></TR><TR><TD><P>00018</P></TD><TD><P>Employee</P></TD><TD><P>Martini</P></TD><TD><P>Drink</P></TD></TR><TR><TD><P>00017</P></TD><TD><P>Employee</P></TD><TD><P>French 75</P></TD><TD><P>Drink</P></TD></TR><TR><TD><P>00016</P></TD><TD><P>Guest</P></TD><TD><P>Mint Julep</P></TD><TD><P>Drink</P></TD></TR><TR><TD><P>00015</P></TD><TD><P>Employee</P></TD><TD><P>Sidecar</P></TD><TD><P>Drink</P></TD></TR><TR><TD><P>00014</P></TD><TD><P>Guest</P></TD><TD><P>Sidecar</P></TD><TD><P>Drink</P></TD></TR><TR><TD><P>00013</P></TD><TD><P>Guest</P></TD><TD><P>Pimm's Cup</P></TD><TD><P>Drink</P></TD></TR><TR><TD><P>00012</P></TD><TD><P>Employee</P></TD><TD><P>Gimlet</P></TD><TD><P>Drink</P></TD></TR><TR><TD><P>00011</P></TD><TD><P>Guest</P></TD><TD><P>Mimosa</P></TD><TD><P>Drink</P></TD></TR><TR><TD><P>00010</P></TD><TD><P>Guest</P></TD><TD><P>Mimosa</P></TD><TD><P>Drink</P></TD></TR><TR><TD><P>00009</P></TD><TD><P>Employee</P></TD><TD><P>Whiskey Sour</P></TD><TD><P>Drink</P></TD></TR><TR><TD><P>00008</P></TD><TD><P>Guest</P></TD><TD><P>Manhattan</P></TD><TD><P>Drink</P></TD></TR><TR><TD><P>00007</P></TD><TD><P>Guest</P></TD><TD><P>Cheeseburger</P></TD><TD><P>Food</P></TD></TR><TR><TD><P>00006</P></TD><TD><P>Guest</P></TD><TD><P>Reuben</P></TD><TD><P>Food</P></TD></TR><TR><TD><P>00005</P></TD><TD><P>Employee</P></TD><TD><P>Po'boy</P></TD><TD><P>Food</P></TD></TR><TR><TD><P>00004</P></TD><TD><P>Guest</P></TD><TD><P>BLT</P></TD><TD><P>Food</P></TD></TR><TR><TD><P>00003</P></TD><TD><P>Employee</P></TD><TD><P>BLT</P></TD><TD><P>Food</P></TD></TR><TR><TD><P>00002</P></TD><TD><P>Guest</P></TD><TD><P>Cioppino</P></TD><TD><P>Food</P></TD></TR><TR><TD><P>00001</P></TD><TD><P>Guest</P></TD><TD><P>Cioppino</P></TD><TD><P>Food</P></TD></TR></TBODY></TABLE> Sat, 22 Dec 2018 20:57:50 GMT https://community.qlik.com/t5/App-Development/Different-dimensions-same-table/m-p/1523606#M37564 Anonymous 2018-12-22T20:57:50Z https://community.qlik.com/t5/App-Development/Different-dimensions-same-table/m-p/1523615#M37566 <P>add chart</P><P>Dimension:Product type</P><P>&nbsp;</P><P>=Count(&nbsp; {&lt;[Consumer Type]={'Guest'}&gt;}[Product Type])</P> Sun, 23 Dec 2018 08:58:47 GMT https://community.qlik.com/t5/App-Development/Different-dimensions-same-table/m-p/1523615#M37566 Channa 2018-12-23T08:58:47Z