topic Re: Fix table to remove extra rows in QlikView

Fix table to remove extra rows

s_mapper319 — Sat, 16 Nov 2024 17:56:44 GMT

Hi there - this is likely a simple issue related to how I have set up the columns of the table. How do I fix the following table (see picture below) so that all the values for one week exist on the same line, rather than being split up for each day?

My data is set up so that each day exists as a separate column. Thanks in advance for any help!

Re: Fix table to remove extra rows

Anil_Babu_Samineni — Tue, 20 Oct 2020 16:45:18 GMT

Please attach QVW or QVF?

Re: Fix table to remove extra rows

s_mapper319 — Wed, 21 Oct 2020 09:04:15 GMT

I'm sorry, I don't actually know how to do that. I'm using Qlik Sense Enterprise, and I'm not an Administrator. Unfortunately, I think it means that my role and what I'm allowed to do with apps is somewhat limited. Is there other information I can share instead?

Re: Fix table to remove extra rows

MayilVahanan — Wed, 21 Oct 2020 09:20:04 GMT

Hi @s_mapper319

Instead of using Date, you can use Week as dimension.
Because, due to date dimension, values are display in separate lines.

Re: Fix table to remove extra rows

s_mapper319 — Wed, 21 Oct 2020 09:29:12 GMT

Thanks for your response. The leftmost "date" column in my image above is actually already showing Weeks, so unfortunately that doesn't change anything.

If it's helpful, each of my day columns (Mon-Sun) are set up like this:

=if(1*WeekDay(date) = 0, data)

I also have "include null values" checked, otherwise the values disappear.

Re: Fix table to remove extra rows

s_mapper319 — Wed, 21 Oct 2020 14:35:57 GMT

I solved the issue by using a pivot table instead, and including weekdays as dimension columns.