Discussion Board for collaboration related to QlikView App Development.
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!
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?
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.