topic Columns in straight table in QlikView https://community.qlik.com/t5/QlikView/Columns-in-straight-table/m-p/1128618#M917806 <HTML><HEAD></HEAD><BODY><P>Hey Guys,</P><P></P><P>Please check the attachment. The following explanation is what I want to achieve with the info from the client <STRONG>Meerkring Org</STRONG>.</P><P>From the first table, in the month of may (Maand) Mei in dutch we receive two invoices € 670,73 for Gas consumption and € 487,35 for electricity. As you can see from the <STRONG>Energy Type </STRONG>list box, the client has <STRONG>electra</STRONG> and <STRONG>gas</STRONG> connections. Now in the second table below I added the column <STRONG style="font-size: 13.3333px;">Energy Type </STRONG>and the result is not what I expected.For Mei, the records are showing electra and gas twice for each of the amounts. But what I want is: The M<STRONG>aand Mei </STRONG>should still show two records as in the first table with € <SPAN style="font-size: 13.3333px;">670,73&nbsp; associated to gas and <SPAN style="font-size: 13.3333px;">€ 487,35 associated to electra respectively.And from Jun through to Sep all those amounts are for gas but as you can see from the second table the same amounts are associated to both connections.</SPAN></SPAN></P><P></P><P>Please any help on how to resolved these issue will be truly appreciated.</P><P></P><P>Thanks,</P><P>Simon.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Columns in straight table https://community.qlik.com/t5/QlikView/Columns-in-straight-table/m-p/1128618#M917806 <HTML><HEAD></HEAD><BODY><P>Hey Guys,</P><P></P><P>Please check the attachment. The following explanation is what I want to achieve with the info from the client <STRONG>Meerkring Org</STRONG>.</P><P>From the first table, in the month of may (Maand) Mei in dutch we receive two invoices € 670,73 for Gas consumption and € 487,35 for electricity. As you can see from the <STRONG>Energy Type </STRONG>list box, the client has <STRONG>electra</STRONG> and <STRONG>gas</STRONG> connections. Now in the second table below I added the column <STRONG style="font-size: 13.3333px;">Energy Type </STRONG>and the result is not what I expected.For Mei, the records are showing electra and gas twice for each of the amounts. But what I want is: The M<STRONG>aand Mei </STRONG>should still show two records as in the first table with € <SPAN style="font-size: 13.3333px;">670,73&nbsp; associated to gas and <SPAN style="font-size: 13.3333px;">€ 487,35 associated to electra respectively.And from Jun through to Sep all those amounts are for gas but as you can see from the second table the same amounts are associated to both connections.</SPAN></SPAN></P><P></P><P>Please any help on how to resolved these issue will be truly appreciated.</P><P></P><P>Thanks,</P><P>Simon.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Columns-in-straight-table/m-p/1128618#M917806 2020-11-25T16:16:04Z Re: Columns in straight table https://community.qlik.com/t5/QlikView/Columns-in-straight-table/m-p/1128619#M917807 <HTML><HEAD></HEAD><BODY><P>please share your data model ...we need to check how the data is associated <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Thu, 12 May 2016 07:32:02 GMT https://community.qlik.com/t5/QlikView/Columns-in-straight-table/m-p/1128619#M917807 avinashelite 2016-05-12T07:32:02Z Re: Columns in straight table https://community.qlik.com/t5/QlikView/Columns-in-straight-table/m-p/1128620#M917808 <HTML><HEAD></HEAD><BODY><P>Hey Avinash,</P><P>Please I just sent you the data model.</P></BODY></HTML> Thu, 12 May 2016 07:41:44 GMT https://community.qlik.com/t5/QlikView/Columns-in-straight-table/m-p/1128620#M917808 2016-05-12T07:41:44Z