Set Analysis

Thu, 05 Feb 2015 04:36:32 GMT

Hi ,

Pls help with set Analysis..Sample data & Required Result attached.

Thanks in advance..

Sub2u

Re: Set Analysis

manojkulkarni — Thu, 05 Feb 2015 05:16:46 GMT

Use variables to calculate sales between two dates. Start date will be your Month Start of fiscal year and End date will be the last date of selected month. You can use both these variables to get sales between selected period

set

st_date=

date(monthstart(FirstMonthOfFiscalYear),'YYYY-MM-DD');

set

en_date=

date(monthend(Max(SelectedMonthYear)),'YYYY-MM-DD');

= sum({<bill_date={">=$(=st_date) <=$(=en_date)"}>}sales)

topic Set Analysis in QlikView

Set Analysis

Re: Set Analysis