set analysis to display daily sales

[#1]

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?

you help will be greatly appreciated.

[swuehl · Accepted solution]

I assume you've created a Day field in your load with numeric values, 1 to 31.

And you select on Month field to see the current month.

You can create your daily sales expressions in a straight table chart like

=sum({<Day = {1}>} YourSalesField)

=sum({<Day = {2}>} YourSalesField)

=sum({<Day = {3}>} YourSalesField)

...

For the upcoming days in a month, the expression should return zero. You can also use conditional expressions (using QV11 only) in expression tab to hide the column completely:

= 1 <= Day(today())

= 2 <= Day(today())

= 3 <= Day(today())

...