Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I need to create a status tab in an app that will read from an Excel file. The data in here does not need to be associated in any way with the data model but I'm struggling to think of a way to create this layout in the UI. Any suggestions on how to recreate this formatted Excel look in QV? The users would be updating the statuses on the Excel file and then when QV refreshes they'd be updated on the status tab.
Thank you.
Hi Mark,
you could try like (pivot table like whiteline suggested):
which I think is coming quite close to your request:
The color coding of the Status expression is done like this:
hope this helps
regards
Marco
Hi.
I guess the time periods are dynamic.
So you can create pivot table. ENTITY, Description, Time period as dimensions and Status, Date Updated as expressions. Then drag Time period to the right until the blue horizontal arrow appears.
Hi Mark,
you could try like (pivot table like whiteline suggested):
which I think is coming quite close to your request:
The color coding of the Status expression is done like this:
hope this helps
regards
Marco