hi guys, i am new to qlikview and need some urgent help.
i am working on a sales report with multiple expressions. one of the things i need to do is create a sales column for each day of the month.
ideally the report should only show the column once the date has passed, e.g. on the 5th of the month i want to see 4 columns with sales data for the first 4 days of that month and on the 20th i want to see 19 columns.
As a compromise i can display all 31 columns from the beginning of the month but each column only gets populated with the sales as the month progresses. i have other expressions on this report that i dont want to see in this way so i cant just create a 'crosstable' with 'Day' going across as it would affect all the expressions on the report. is there a specific kind of chart that i need to use to achieve this? if i need to use a set analysis, which is my guess, how do i write this?