topic Re: Need help with Set Analysis in QlikView

Need help with Set Analysis

Sun, 07 Jun 2015 10:45:40 GMT

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.

Re: Need help with Set Analysis

kaushiknsolanki — Sun, 07 Jun 2015 10:48:16 GMT

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

Re: Need help with Set Analysis

Sun, 07 Jun 2015 11:21:13 GMT

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

Re: Need help with Set Analysis

kaushiknsolanki — Sun, 07 Jun 2015 11:23:23 GMT

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

Re: Need help with Set Analysis

hic — Sun, 07 Jun 2015 18:09:30 GMT

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