topic Previous six month data without set amalysis in QlikView

Previous six month data without set amalysis

Anonymous — Fri, 19 Aug 2016 02:12:28 GMT

Hi All,

i have a date(mmm yy) dimension coming from master calendar table. Currently it is showing all the date in the chart i.e from jan 2015 to current date.

Month yr, Amount

Jan 15,10000

feb 15, 20000

MAr 15,30000

AUg 16, 220000.

now when i select particular month from calendar lets say jul 16 the chart should show only prev six month i.e

feb 16,111111

mar 16,22222

apr 16,333333

may 16,444444

jun 16, 555655

july 16,666666

looking for solution with out set analysis. Any help would be appreciated. Thanks

Re: Previous six month data without set amalysis

arusanah — Fri, 19 Aug 2016 02:45:58 GMT

create two variables as

varBeginDate= Date(MonthStart(Max([Date])),'MM/DD/YYYY')

varEndDate=Date(addmonths(MonthStart(Max([Date])),-6),'MM/DD/YYYY')

expression should go like :

Count( {<[Date]={">$(varBeginDate)<=$(varBeginDate)"} <field that you are counting >)

Re: Previous six month data without set amalysis

Anonymous — Fri, 19 Aug 2016 06:44:45 GMT

Hi manoj,

If you dont use Set Analisys your calendar must be separated from the other tables, because you will select only one month, and you will show only one month.

Regards.