topic Returning Too Many Rows When New Dimension Is Added in QlikView

Returning Too Many Rows When New Dimension Is Added

pnn44794 — Sat, 12 Oct 2019 21:45:49 GMT

Hello:

I have a straight table where I need to add a new column called Network Zone. Before I add Network Zone, I have a total of 7,330 rows of data. After I add Network Zone, I get 9,268 rows of data. The row count should not change. I believe I may need to add Network Zone as a calculated dimension perhaps, but I'm open to suggestions. I say calculated dimension so I would have the ability to put the column wherever I'd like to. If there is no value for Network Zone, that's fine as it can be blank for a row. I have attached a spreadsheet that includes Network Zone that results in 9,268 rows which is incorrect (again, should be 7,330 rows).

As always, thanks in advance for any and all help and responses.

Re: Returning Too Many Rows When New Dimension Is Added

Digvijay_Singh — Thu, 01 Mar 2018 17:34:57 GMT

Your data file has 9268 records in your attached file? See the count at the bottom of below image.

Re: Returning Too Many Rows When New Dimension Is Added

pnn44794 — Thu, 01 Mar 2018 17:59:43 GMT

Sorry about that. Not sure what happened. I'm running another export and will check it before attaching it. Do you know if there is a size limitation for attachments?

Re: Returning Too Many Rows When New Dimension Is Added

Digvijay_Singh — Thu, 01 Mar 2018 18:04:54 GMT

You mean along with replies here?

I see this when I try to attach any file -

Re: Returning Too Many Rows When New Dimension Is Added

pnn44794 — Sat, 12 Oct 2019 21:47:17 GMT

Ok. That's weird. I added RowNo(TOTAL) as an expression and it shows 9,268 on the last row. I exported it and that's what is there.

Re: Returning Too Many Rows When New Dimension Is Added

pnn44794 — Thu, 01 Mar 2018 18:49:54 GMT

Ok. It looks like it's all there now. I'm not sure what happened the first time I attached it.

Re: Returning Too Many Rows When New Dimension Is Added

pnn44794 — Fri, 02 Mar 2018 19:44:39 GMT

Any ideas or is what I'm looking for not doable?

Re: Returning Too Many Rows When New Dimension Is Added

vishsaggi — Fri, 02 Mar 2018 20:02:10 GMT

I can still see 9269 rows in this excel sheet is that correct?

Re: Returning Too Many Rows When New Dimension Is Added

Digvijay_Singh — Fri, 02 Mar 2018 20:05:06 GMT

Are All the fields in your straight table are coming from same table or different table? Is the network zone is coming from separate table? You would want to check for the duplicates or no match of the keys associating those tables if they exists in separate table, they might result in extra rows in your straight table.

Re: Returning Too Many Rows When New Dimension Is Added

pnn44794 — Fri, 02 Mar 2018 20:05:17 GMT

That is how many that are in the spreadsheet. Before I added the Network Zone dimension, there was 7,330 rows. That's how many that should be there after adding the Network Zone dimension and not 9,268.

Re: Returning Too Many Rows When New Dimension Is Added

vishsaggi — Fri, 02 Mar 2018 20:09:20 GMT

When you say you are adding Networkzone dimension, can you show the script where you adding this dimension field?

Re: Returning Too Many Rows When New Dimension Is Added

Digvijay_Singh — Fri, 02 Mar 2018 20:16:50 GMT

Before adding Network Zone, did you have such duplicates? I see no difference other than 2 network zone values(Space and ESF), you can match this with the file without network zone, if you see one record, means your number of records are getting increased due to undesired data model associations. It would be my bad if I missed finding the difference or you had two such records before as well.

Re: Returning Too Many Rows When New Dimension Is Added

pnn44794 — Sat, 12 Oct 2019 21:48:23 GMT

It's just one line of many.

Or are you asking to see the whole load script? As an FYI, I'm about to go offline but will be back online in about an hour.

Re: Returning Too Many Rows When New Dimension Is Added

pnn44794 — Fri, 02 Mar 2018 20:22:52 GMT

Before adding Network Zone, I had no dups. I think you're right. It's my data model. Network Zone does indeed come from another table, though both tables are linked by ORDER_ID. However, I think I may be using the wrong one. There's a few. As mentioned in my response to Vishwarath, I'm about to go offline for about an hour and will be back on then. I'll try a different Order ID field.

Re: Returning Too Many Rows When New Dimension Is Added

vishsaggi — Fri, 02 Mar 2018 20:27:05 GMT

I wanted to know if you were adding this column in the script and generating data to Excel?

Re: Returning Too Many Rows When New Dimension Is Added

pnn44794 — Fri, 02 Mar 2018 22:02:30 GMT

Yes. I am loading the dimension via the load script, adding the dimension to a straight table and then exporting the data from Qlikview to Excel. My end users access this dashboard and often want to export the data to Excel.

Re: Returning Too Many Rows When New Dimension Is Added

vishsaggi — Sat, 03 Mar 2018 03:12:15 GMT

As Vijay mentioned please check your data model and see how many rows are matching to your networkzone dimension table.

Re: Returning Too Many Rows When New Dimension Is Added

pnn44794 — Mon, 05 Mar 2018 18:03:12 GMT

Hello Digvijay:

My apologies for the delay in getting back to you. You are correct. I have a problem with my data model that I need to fix. I will mark your answer as correct. Thank you for responding to me.

Re: Returning Too Many Rows When New Dimension Is Added

pnn44794 — Mon, 05 Mar 2018 18:04:48 GMT

Hello Vishwarath:

My apologies for the delay in getting back to you. As you mentioned, Digvijay is correct in that I have a problem with my data model which I'll have to fix. Thank you for responding..