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

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

Wed, 25 Nov 2020 16:16:04 GMT

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

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

perumal_41 — Tue, 24 May 2016 12:18:09 GMT

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)

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

swuehl — Tue, 24 May 2016 12:20:32 GMT

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‌

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

Tue, 24 May 2016 13:01:56 GMT

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