topic Re: Set Analisys with month condition in QlikView

Set Analisys with month condition

Tue, 10 Jun 2014 06:58:42 GMT

Dear all,

I´d like to use set analysis with a month condition for one of the fields, but I´m getting errors doing it.

Could you please seeing the script what I´m doing wrong? (the last sentece is giving me problems)

({<[Fehl.Mng.fremd]={">0"}>}(NAS))and
count({<[Vorlagennummer]={">0"}>}(NAS)) and
count({<[Meldungsart]={"Q2"}>}(NAS))and
count({<Month([Angelegt am])=Month(AddMonths(Today(),-1))>}(NAS))

Thanks and regards.

Asier

Re: Set Analisys with month condition

tresB — Tue, 10 Jun 2014 07:02:17 GMT

Problematic area -count({<Month([Angelegt am])=

It would be somewhat like: Count ({<YourMonthField={"$(=Month(AddMonths(Today(),-1)))"}>}

Re: Set Analisys with month condition

Tue, 10 Jun 2014 08:35:57 GMT

Thanks treseco for the quick reply.

Where you write YourMonthField, could it be replace for count({<Month([YourMonthField])=...

I´m no getting any value with the suggested change.

Kind regards.

Asier

Re: Set Analisys with month condition

MK_QSL — Tue, 10 Jun 2014 08:36:55 GMT

({<[Fehl.Mng.fremd]={">0"}>}(NAS))and
count({<[Vorlagennummer]={">0"}>}(NAS)) and
count({<[Meldungsart]={"Q2"}>}(NAS))and
count({<Month([Angelegt am])=Month(AddMonths(Today(),-1))>}(NAS))

You have provided set analysis but the aggregation function missing...

COUNT/SUM/AVG (YOUR ABOVE EXPRESSION)YourDimesion

Re: Set Analisys with month condition

Tue, 10 Jun 2014 08:54:01 GMT

Yes. Sorry that was a paste mistake.

The error comes from the last sentence.

count({<Month([Angelegt am])=Month(AddMonths(Today(),-1))>}(NAS))

I´ve just changed in the scprit the Field [Angelegt am]) for Month([Angelegt am]) as Monat and now I have this sentence, which is still not working ...

count({$1<[Monat]={"<=$(=Month(AddMonths(Today(),-1)))"}>}NAS)

Any ideas?

Re: Set Analisys with month condition

MK_QSL — Tue, 10 Jun 2014 08:56:52 GMT

count({$1<[Monat]={"<=$(=Month(AddMonths(Today(),-1)))"}>}NAS)

Looks like your Monat is in different format.... You need to convert the data format to match something like below

What is the Monat format?