topic Re: Issue with pivot hypercube in a mashup in Integration, Extension & APIs https://community.qlik.com/t5/Integration-Extension-APIs/Issue-with-pivot-hypercube-in-a-mashup/m-p/1308491#M7307 <HTML><HEAD></HEAD><BODY><P>I needed to add "qNoOfLeftDims": 1</P></BODY></HTML> Wed, 12 Apr 2017 13:37:09 GMT 2017-04-12T13:37:09Z Issue with pivot hypercube in a mashup https://community.qlik.com/t5/Integration-Extension-APIs/Issue-with-pivot-hypercube-in-a-mashup/m-p/1308490#M7306 <HTML><HEAD></HEAD><BODY><P>I'm trying to create a pivot hypercube with two dimensions in a mashup, but I can't get it to use the second dimension, it just sums by the first one.</P><P>I created the hypercube using the Hypercube builder.</P><P>Am I doing something wrong or is this a limitation of Qlik Sense?</P><P></P><P>Input data -</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Option</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Duration</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Value</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">0.1</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1.5</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1.25</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">2.1</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1.6</TD></TR></TBODY></TABLE><P></P><P>What I want -</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Option</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>3</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">0.1</TD><TD style="padding: 2px;">1.5</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">1.25</TD><TD style="padding: 2px;">2.1</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;">1.6</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P><SPAN style="font-size: 10pt;">What I get -</SPAN></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Option</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Sum(Value)</TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">3.6</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">3.35</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">1.6</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 30 Mar 2017 10:26:16 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Issue-with-pivot-hypercube-in-a-mashup/m-p/1308490#M7306 2017-03-30T10:26:16Z Re: Issue with pivot hypercube in a mashup https://community.qlik.com/t5/Integration-Extension-APIs/Issue-with-pivot-hypercube-in-a-mashup/m-p/1308491#M7307 <HTML><HEAD></HEAD><BODY><P>I needed to add "qNoOfLeftDims": 1</P></BODY></HTML> Wed, 12 Apr 2017 13:37:09 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Issue-with-pivot-hypercube-in-a-mashup/m-p/1308491#M7307 2017-04-12T13:37:09Z