Need help with Set Analysis

[#1]

I want show the summary of Sum of field Amount for following in different textboxes

1. Today- Should show only the sum of amount for Today

2. yesterday- Should Show the Sum of amount for Yesterday

3. Last 7 Days- Should show the Sum of amount for last 7 days

4.  This Week- Should show the Sum of amount for current week

5 . This Month- Current Month

I have a master calendar but don't want the selection of of Year Month and day to impact the above values.

[kaushiknsolanki]

Hi,

You can create a set analysis like below.

Sum{<Date = {"$(=today())"},Month=,Year=,Quarter=>}Sales)

Like wise you can create for all other logic, just need to make sure that you deselect the Month, Year, Quarter or any other field of master cal, which you have as a selection.

Regards,

Kaushik Solanki

[#3]

Thanks .. I am very new to qlikview can you help for other also

[kaushiknsolanki]

Here it is.

Sum{<Date = {"$(=today())"},Month=,Year=,Quarter=>}Sales)

Sum{<Date = {">=$(=today()-1)"},Month=,Year=,Quarter=>}Sales)

Sum{<Date = {">=$(=today()-7)"},Month=,Year=,Quarter=>}Sales)

Sum{<Date = {">=$(=Monthstart(today()))"},Month=,Year=,Quarter=>}Sales)

Sum{<Date = {">=$(=Yearstart(today()))"},Month=,Year=,Quarter=>}Sales)

Regards,

Kaushik Solanki

[hic]

You should definitely do what Kaushik suggest. I would however do it by defining flags in the script. That way the Set Analysis expression gets much simpler.

See

https://community.qlik.com/blogs/qlikviewdesignblog/2013/06/10/relative-calendar-fields

https://community.qlik.com/blogs/qlikviewdesignblog/2012/12/07/booleans

https://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd

HIC