topic Re: issue regarding scenario in QlikView https://community.qlik.com/t5/QlikView/issue-regarding-scenario/m-p/1313503#M843586 <HTML><HEAD></HEAD><BODY><P>Take Straight table and use</P><P>Dimension - cid</P><P>Expression - Sum(amount)</P></BODY></HTML> Thu, 13 Apr 2017 07:26:45 GMT Anil_Babu_Samineni 2017-04-13T07:26:45Z issue regarding scenario https://community.qlik.com/t5/QlikView/issue-regarding-scenario/m-p/1313502#M843585 <HTML><HEAD></HEAD><BODY><P>if i have a tables like below </P><P>cid&nbsp;&nbsp;&nbsp;&nbsp; amount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cid&nbsp;&nbsp;&nbsp;&nbsp; amount<SPAN style="font-size: 10pt;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P>101&nbsp;&nbsp;&nbsp;&nbsp; 50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 102&nbsp;&nbsp;&nbsp; 200</P><P>102&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 103&nbsp;&nbsp;&nbsp; 100 </P><P>103&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 104&nbsp;&nbsp;&nbsp;&nbsp; 300</P><P>104&nbsp;&nbsp;&nbsp;&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 105&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P>105&nbsp;&nbsp;&nbsp;&nbsp; 500</P><P></P><P>now chart has to show the total sales i.e. for 102 cid total sales is 100+200= 300<SPAN style="font-size: 10pt;">&nbsp; </SPAN></P><P>like below</P><P>cid&nbsp;&nbsp;&nbsp;&nbsp; amount</P><P>101&nbsp;&nbsp;&nbsp; 50</P><P>102&nbsp;&nbsp;&nbsp; 300</P><P>103&nbsp;&nbsp;&nbsp; 500</P><P>104&nbsp;&nbsp;&nbsp; 600</P><P>105&nbsp;&nbsp;&nbsp; 700</P><P>please help me</P><P>thanks in advance </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/issue-regarding-scenario/m-p/1313502#M843585 2020-11-25T16:16:04Z Re: issue regarding scenario https://community.qlik.com/t5/QlikView/issue-regarding-scenario/m-p/1313503#M843586 <HTML><HEAD></HEAD><BODY><P>Take Straight table and use</P><P>Dimension - cid</P><P>Expression - Sum(amount)</P></BODY></HTML> Thu, 13 Apr 2017 07:26:45 GMT https://community.qlik.com/t5/QlikView/issue-regarding-scenario/m-p/1313503#M843586 Anil_Babu_Samineni 2017-04-13T07:26:45Z Re: issue regarding scenario https://community.qlik.com/t5/QlikView/issue-regarding-scenario/m-p/1313504#M843587 <HTML><HEAD></HEAD><BODY><P>Hi Kenchala,</P><P></P><P>You must be missing the same column name , it is amount instead of amound</P><P></P><P>See code below:</P><P></P><P>T1:</P><P>Load * inline</P><P>[</P><P>cid,&nbsp;&nbsp;&nbsp; amount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>101&nbsp; ,&nbsp; 50&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>102 ,&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>103&nbsp; ,&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>104&nbsp; ,&nbsp; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>105&nbsp; ,&nbsp; 500</P><P>];</P><P></P><P></P><P></P><P></P><P>t2:</P><P>Load * Inline</P><P>[</P><P>cid, amount</P><P>102,200</P><P>103,100</P><P>104,300</P><P>105,200</P><P>];</P><P></P><P>find the attached example</P></BODY></HTML> Thu, 13 Apr 2017 07:46:02 GMT https://community.qlik.com/t5/QlikView/issue-regarding-scenario/m-p/1313504#M843587 Siva_Sankar 2017-04-13T07:46:02Z