topic Re: Set Analysis as variable into another set analysis in QlikView

Set Analysis as variable into another set analysis

Wed, 26 Nov 2014 08:33:49 GMT

Hey Community,

i need your help with a set analysis problem. I have defined variables by using set analysis. If I put them into a textbox I get the right result.

Here two examples:

vStart_PriorYear

=if (vOhneAuswahl = 0, date(AddYears(YearStart(Min({<%Artikelnr=,%Statistikklasse=,%KreditorNr=>} today())),-1)),

IF(MonthStart(Min({<%Artikelnr=,%Statistikklasse=,%KreditorNr=>} %Datum))> today(),

date(AddYears(MonthStart(Min({<%Artikelnr=,%Statistikklasse=,%KreditorNr=>}%Datum)),-1))))

vEnd_PriorYear

=IF(MonthStart(Min({<%Artikelnr=,%Statistikklasse=,%KreditorNr=>} %Datum))> today(),

If(MonthEnd(Max({<%Artikelnr=,%Statistikklasse=,%KreditorNr=>} %Datum))<today(),

date(AddYears(MonthEnd(Max({<%Artikelnr=,%Statistikklasse=,%KreditorNr=>}%Datum)),-1)),

date(AddYears(today(),-1))))

Now I would like to use those variables in another set analysis. And that is my PROBLEM. I cannot make it work!!!

Here is the set analysis that is not working.

= Sum({<%Datum={'>=$(vStart_PriorYear)<=$(vEnd_PriorYear)'}>} [Sales])

Thanks a lot!

Martin

Re: Set Analysis as variable into another set analysis

Gysbert_Wassenaar — Wed, 26 Nov 2014 09:14:52 GMT

Could be something to do with the date format of the values in your variables. Can you post a document that demonstrates the problem?

Re: Set Analysis as variable into another set analysis

Wed, 26 Nov 2014 10:22:10 GMT

I have solved the problem myself.

I forget to exclude the selection in my calendar.

My working set analysis looks now like that.

= Sum({<Calendar.Jahr=, Calendar.Quartal=, Calendar.Monat=, Calendar.EindeutigerMonat=, %Datum={'>=$(vStart_PriorYear)<=$(vEnd_PriorYear)'}>} [Sales])

Thanks anyways for your quick response