Fix table to remove extra rows

[s_mapper319]

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!

[Anil_Babu_Samineni]

Please attach QVW or QVF?

[s_mapper319]

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?

[MayilVahanan]

Hi @s_mapper319 

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

[s_mapper319]

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.

[s_mapper319 · Accepted solution]

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