topic SetAnalysis not working with selection in QlikView

SetAnalysis not working with selection

Wed, 05 Nov 2014 07:54:46 GMT

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

Re: SetAnalysis not working with selection

ali_hijazi — Wed, 05 Nov 2014 08:07:53 GMT

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

Re: SetAnalysis not working with selection

MK_QSL — Wed, 05 Nov 2014 08:08:14 GMT

=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....

Re: SetAnalysis not working with selection

preminqlik — Wed, 05 Nov 2014 08:18:26 GMT

use max function like below

=count(

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

[Server physisch/virtuell])

Re: SetAnalysis not working with selection

Wed, 05 Nov 2014 08:55:10 GMT

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?