topic Re: Qlikview chart format ,Help required in QlikView https://community.qlik.com/t5/QlikView/Qlikview-chart-format-Help-required/m-p/791654#M534269 <HTML><HEAD></HEAD><BODY><P>Can you attach an example to show Data?</P><P></P><P>As an&nbsp; example, I have a dimension naming States and a dimension naming Cities and I have an expression to show sum of sales.</P><P></P><P><STRONG>States&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cities&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sum(Sales)</STRONG></P><P>Haryana&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Gurgaon&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7000</P><P>Haryana&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sonepat&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5000</P><P>Maharashtra&nbsp; Mumbai&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6000</P><P><SPAN style="font-size: 13.3333330154419px;">Maharashtra </SPAN>&nbsp; Pune&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3000</P><P></P><P>Now, Always Sum of sales will be calculated on City. As City is subset of state.</P><P></P><P>Do you want like this : </P><P style="font-size: 13.3333330154419px;"><STRONG>States&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cities&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sum(Sales) by City&nbsp;&nbsp;&nbsp;&nbsp; Sum(Sales) by state</STRONG></P><P style="font-size: 13.3333330154419px;">Haryana&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Gurgaon&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12000</P><P style="font-size: 13.3333330154419px;">Haryana&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sonepat&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12000</P><P style="font-size: 13.3333330154419px;">Maharashtra&nbsp; Mumbai&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9000</P><P style="font-size: 13.3333330154419px;"><SPAN style="font-size: 13.3333330154419px;">Maharashtra </SPAN>&nbsp; Pune&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9000</P><P></P><P>??</P></BODY></HTML> Fri, 27 Feb 2015 10:31:26 GMT timanshu 2015-02-27T10:31:26Z Qlikview chart format ,Help required https://community.qlik.com/t5/QlikView/Qlikview-chart-format-Help-required/m-p/791648#M534263 <HTML><HEAD></HEAD><BODY><P>In the chart below , I have two different dimensions with different metrics for each value. I want to know if this format is possible in Straight or Pivot chart in Qlikview. Any help would be highly appreciated.</P><P></P><P>Please find below the screenshot of the format I require.</P><P>Thanks in Advance</P><P></P><P><IMG src="https://community.qlik.com/" /></P></BODY></HTML> Thu, 26 Feb 2015 04:40:50 GMT https://community.qlik.com/t5/QlikView/Qlikview-chart-format-Help-required/m-p/791648#M534263 2015-02-26T04:40:50Z Re: Qlikview chart format ,Help required https://community.qlik.com/t5/QlikView/Qlikview-chart-format-Help-required/m-p/791649#M534264 <HTML><HEAD></HEAD><BODY><P>screenshot is missing</P></BODY></HTML> Thu, 26 Feb 2015 20:14:01 GMT https://community.qlik.com/t5/QlikView/Qlikview-chart-format-Help-required/m-p/791649#M534264 maxgro 2015-02-26T20:14:01Z Re: Qlikview chart format ,Help required https://community.qlik.com/t5/QlikView/Qlikview-chart-format-Help-required/m-p/791650#M534265 <HTML><HEAD></HEAD><BODY><P><IMG alt="Format1.jpg" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/79385_Format1.jpg" style="width: 620px; height: 264px;" /></P></BODY></HTML> Fri, 27 Feb 2015 04:19:12 GMT https://community.qlik.com/t5/QlikView/Qlikview-chart-format-Help-required/m-p/791650#M534265 2015-02-27T04:19:12Z Re: Qlikview chart format ,Help required https://community.qlik.com/t5/QlikView/Qlikview-chart-format-Help-required/m-p/791651#M534266 <HTML><HEAD></HEAD><BODY><P>Sorry it was not uploaded.. This is the format of the report I need. Please suggest.</P></BODY></HTML> Fri, 27 Feb 2015 04:20:22 GMT https://community.qlik.com/t5/QlikView/Qlikview-chart-format-Help-required/m-p/791651#M534266 2015-02-27T04:20:22Z Re: Qlikview chart format ,Help required https://community.qlik.com/t5/QlikView/Qlikview-chart-format-Help-required/m-p/791652#M534267 <HTML><HEAD></HEAD><BODY><P>Hi Nitesh,</P><P>According to information provided by you, I think you want to display expression different and separate for different dimensions.</P><P>But the values of any expression for&nbsp; two dimensions in a row will be always same, if the dimensions are linked by some way.</P><P></P><P>Taking your data as example.</P><P>Dimension1 and 1&nbsp; are two dimension values in a row. And any expression will give same result corresponding to any of these two dimensions.</P><P></P><P>If, your issue is something different from this, kindly attach your application for better understanding.</P></BODY></HTML> Fri, 27 Feb 2015 05:22:36 GMT https://community.qlik.com/t5/QlikView/Qlikview-chart-format-Help-required/m-p/791652#M534267 timanshu 2015-02-27T05:22:36Z Re: Qlikview chart format ,Help required https://community.qlik.com/t5/QlikView/Qlikview-chart-format-Help-required/m-p/791653#M534268 <HTML><HEAD></HEAD><BODY><P>hi <A _jive_internal="true" data-avatarid="1034" data-externalid="" data-online="false" data-presence="null" data-userid="184787" data-username="Timanshu" href="https://community.qlik.com/people/Timanshu"><STRONG style="color: #8b8b8b;">Timanshu </STRONG></A> :</P><P>Yes you are absolutely correct, this is what I am looking for.</P><P>Apart from this requirement I am also not sure if this kind of chart form is possible in Straight table or Pivot table.I am majorly confused with Designing of this chart. Please suggest</P></BODY></HTML> Fri, 27 Feb 2015 09:53:43 GMT https://community.qlik.com/t5/QlikView/Qlikview-chart-format-Help-required/m-p/791653#M534268 2015-02-27T09:53:43Z Re: Qlikview chart format ,Help required https://community.qlik.com/t5/QlikView/Qlikview-chart-format-Help-required/m-p/791654#M534269 <HTML><HEAD></HEAD><BODY><P>Can you attach an example to show Data?</P><P></P><P>As an&nbsp; example, I have a dimension naming States and a dimension naming Cities and I have an expression to show sum of sales.</P><P></P><P><STRONG>States&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cities&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sum(Sales)</STRONG></P><P>Haryana&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Gurgaon&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7000</P><P>Haryana&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sonepat&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5000</P><P>Maharashtra&nbsp; Mumbai&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6000</P><P><SPAN style="font-size: 13.3333330154419px;">Maharashtra </SPAN>&nbsp; Pune&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3000</P><P></P><P>Now, Always Sum of sales will be calculated on City. As City is subset of state.</P><P></P><P>Do you want like this : </P><P style="font-size: 13.3333330154419px;"><STRONG>States&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cities&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sum(Sales) by City&nbsp;&nbsp;&nbsp;&nbsp; Sum(Sales) by state</STRONG></P><P style="font-size: 13.3333330154419px;">Haryana&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Gurgaon&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12000</P><P style="font-size: 13.3333330154419px;">Haryana&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sonepat&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12000</P><P style="font-size: 13.3333330154419px;">Maharashtra&nbsp; Mumbai&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9000</P><P style="font-size: 13.3333330154419px;"><SPAN style="font-size: 13.3333330154419px;">Maharashtra </SPAN>&nbsp; Pune&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9000</P><P></P><P>??</P></BODY></HTML> Fri, 27 Feb 2015 10:31:26 GMT https://community.qlik.com/t5/QlikView/Qlikview-chart-format-Help-required/m-p/791654#M534269 timanshu 2015-02-27T10:31:26Z