topic Re: Combining Rows With A Total Count in QlikView

Combining Rows With A Total Count

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

Hello:

I have a situation where I need to combine rows

Some additional info. Not all rows have the same Order Date, so the oldest Order Date should be used / returned. Outstanding Units count, I believe, needs to be a calculated dimension so I can place it within the straight table where the users expect it. Host Name should be what's counted as it's guaranteed to have a value.

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

Re: Combining Rows With A Total Count

tamilarasu — Thu, 15 Mar 2018 02:10:46 GMT

Hi Perry,

Have a look at the attached file.

Re: Combining Rows With A Total Count

pnn44794 — Thu, 15 Mar 2018 03:30:06 GMT

Hello Tamil:

Thank you for your response. I can see that your solution absolutely works with what I supplied you. Unfortunately, I think I may have made a mistake. There are a whole bunch of other columns in the dataset, but I have simply hid them. I will dig deeper into that tomorrow and respond back. My apologies.

Re: Combining Rows With A Total Count

tamilarasu — Thu, 15 Mar 2018 03:38:48 GMT

Perry - No worries. If it is not working for other columns kindly let me know. Take your time.

Re: Combining Rows With A Total Count

pnn44794 — Mon, 19 Mar 2018 19:32:25 GMT

Hello Tamil:

My apologies for the delay in replying. Your solution does indeed work, so I will mark it as the correct answer. I do still have a problem though and I will be starting a new discussion and supplying more information. It will be similar, but with more information and data supplied by me. Thank you again for your help.