SetAnalysis not working with selection

[#1]

Hey all

I am running into a problem when using set analysis in order to analyse previous months. I have a field called Period (DD.MM.YYYY) and created year(Period) as well as month(Period) from it. These new fields should serve as navigation. In order to calculate the SetAnalysis i apply the field Period. Unfortunately it is not working when only selecting a year and a month.

Attached you will find an example file.

cheers

Sebastian

[ali_hijazi · Accepted solution]

add to your set analysis Jahr=,Monat=

because when you select a specific Year, and Month then previous 2 months are out of selection

check attached

[MK_QSL]

=count({<Periode = {'$(==Date(AddMonths(MakeDate(Max(Jahr),Max(Monat)),-2)))'}>}[Server physisch/virtuell])

If this is not working, kindly provide sample data in excel file....

[preminqlik]

use max function like below

=count(

{<Periode = {'$(=addmonths(max(Periode),-2))'}>}

[Server physisch/virtuell])

[#5]

This formula worked perfectly, while the others didn't. Thank you!!

Talking about the other ones, both worked when i only extracted the date calculation to a textfield. Eg: ='$(=addmonths(max(Periode),-2))'}

The moment i added it to SetAnalysis it refused to work though. Any explanation for that?