Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table where one of the columns shows a date.
I want to create a List box object that shows all the dates that do not show up in the table (no row contains that date), given a range of dates. Any tips for doing this?
Thanks
maybe you could create a listbox with an expression like
=Aggr(only({<date=e(date)>} date), date)
hope this helps
regards
Marco
I think that would rather depend on the dimensions and expressions in the table as well as settings that affect the number of rows such as dimension limits and zero/null suppression - the best way is to supply a sample qvw document with relevant data and the table under discussion.
Hi again,
one example:
hope this helps
regards
Marco
Well, this only works for dates you select.
What I want is more along the lines of this example:
Say I have a table with a date column and a sales column.
If there are no sales on a particular day, that day does not show up in the table.
So I would want to create a List box that looks through that date column and returns all the dates that simply do not exist in the date column in the table (from the range of the earliest day in the table, to the last day in the table)
This seems to be a lot harder to do than it sounds, I can't figure it out..