Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

set analysis to display daily sales

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.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: set analysis to display daily sales

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())

...

View solution in original post

1 Reply
Highlighted
MVP
MVP

Re: set analysis to display daily sales

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())

...

View solution in original post