Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Not applicable

Set Analysis - sales in daily, weekly, monthly, half year and yearly

Hello all,

I want to create the below image report in my qlikview application.

the expressions are:

Sales                            = sum({$<Year={$(=Only(Year))}>}TransactionQuantity*SalesPrice)

%LY                             = sum ({$<Year={$(=Only(Year)-1)}>}TransactionQuantity*SalesPrice)

&Budget                       = sum(SalesPrice*TransactionQuantity)/ sum(Budget)

Gap Budget                 = sum(SalesPrice*TransactionQuantity) - sum(Budget)

how can i based, on these expressions, create a daily sales, weekly, monthly, half year and yearly sales figures (see red markered zone on the image below)

thank you so much!

Greets,

Rega

3 Replies
Highlighted
Partner
Partner

Re: Set Analysis - sales in daily, weekly, monthly, half year and yearly

Try below like

Daily :

Sales                            = sum({$<Date={$(=max(Date))}>}TransactionQuantity*SalesPrice)

%LD                           = sum ({$<Date={$(=max(Date)-1)}>}TransactionQuantity*SalesPrice)

Weekly :

Sales                            = sum({$<Date={'>=$(=Weekstart(max(Date)))'}>}TransactionQuantity*SalesPrice)

%LD                           = sum ({$<Date={'>=$(=Weekstart(max(Date)-14)) <= >=$(=Weekend(max(Date)-14))'}>}TransactionQuantity*SalesPrice)

Monthly:

Sales                            = sum({$<Month={'$(=max(Month))'},Year={'$(=max(Year))'}>}TransactionQuantity*SalesPrice)

%LD                           = sum ({$<Date={'$(=max(Month)-1)},Year={'$(=max(Year))'}>}TransactionQuantity*SalesPrice)

Highlighted
MVP
MVP

Re: Set Analysis - sales in daily, weekly, monthly, half year and yearly

When you are talking about e.g. Weekly, you mean something like Week-To-Date for this year and last year?

I've learned a lot from this series of blog posts when it came to point in time reporting:

The Magic of Set Analysis - Point In Time Reporting • Blog • AfterSync

Highlighted
Not applicable

Re: Set Analysis - sales in daily, weekly, monthly, half year and yearly

hello Perumal,

none of your expressions don't works .

Would you be so kind to check my application?  please see the tab called TEST.

Thank you so much!

Greets,

Perumal