topic Re: Straight table columns in QlikView

Straight table columns

Wed, 25 Nov 2020 16:16:04 GMT

Hey Guys,

Please check the attachments. The following explanation is what I want to achieve with the info from the clientMeerkring Org.

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 Energy Type list box, the client has electraand gas connections. Now in the second table below I added the column Energy Type 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 Maand Mei should still show two records as in the first table with € 670,73 associated to gas and€ 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.

Please any help on how to resolved these issue will be truly appreciated. I have attached both the table and data model.

Thanks,

Simon.

Re: Straight table columns

marcus_sommer — Thu, 12 May 2016 08:11:24 GMT

I think the reason is your datamodel and that the key-chain from the tables Invoice to Connection to Energy isn't suitable and you might need some redesign between them.

- Marcus

Re: Straight table columns

swuehl — Thu, 12 May 2016 08:11:48 GMT

Seems that this is due to your data model, your relevant tables are only linked by LocationID.

This client seems to have to invoices in this month for this LocationID, and two Energy Types for the same LocationID.

When you combine this in a chart, it makes up for rows, duplicating invoices and Energy Types.

You need to redesign your model.

Re: Straight table columns

Thu, 12 May 2016 08:17:09 GMT

Please any help on how to achieve that? Suggestions, what to link to what and so on.

Thanks.

Re: Straight table columns

swuehl — Thu, 12 May 2016 08:25:47 GMT

That's hard to answer without knowing your data and requirements in detail.

I assume your invoices should show the EnergyType (gas or electricity) somewhere, in a different field, while your connection table is more like a contract?

I would start with

Get started with developing qlik datamodels

Advanced topics for creating a qlik datamodel

Re: Straight table columns

Thu, 12 May 2016 08:30:21 GMT

Thanks