Erorr in set modifier ad hoc element list - only when one specific dimension is added

[phil-ebm]

Hello together

I want to create a chart with 5 dimensions and one expression. 

This is the expression: 

sum( {<

[Rekl Art] = {'Claim','Feldeinsatz','Reklamation','Rework in field','Transport damage','Transportschaden'},
Kalender.Monat=,
[Rekl Entscheidung] = {'ebm-papst Fehler'},
[Material Art]={'Endprodukt'},
RollingMonth24={$(=Concat(DISTINCT Kalender.Monat,','))},
[Rekl RMA Typ] = {'epM'}>}

[Externe Fehler Menge])

The expression is not the problem and is working with 4 of the 5 dimensions.

Using 4 Dimensions I have a result:

Only when I want to add the last specific dimension I get the following error message. 

I checked the result of $(=Concat(DISTINCT Kalender.Monat,',')) if there is an error here but this is working correctly. 

I have no more Ideas what's the problem or how can I find the error because I didn't do a change on the working expression and just adding one additional Dimension. 

Regards 

Philipp

[Stoyan_Terziev]

Hi Phil,

There are several possible explanations to this issue:

1) There is no associated data to your Set Expression filtration

2) There is a problem within the expression itself

3) There is a modelling problem which prevents you from using a dimension not properly linked to the rest of the dataset

Here are few things which may ease off the troubleshooting:

Can you please post a screenshot of the problem?

Can you check if the expression is working if you remove this part: 
RollingMonth24={$(=Concat(DISTINCT Kalender.Monat,','))},

Can you also share a picture of your Data Model?

Kind Regards,

S.T.

[DavidM]

Try this:

RollingMonth24={"$(=Concat(DISTINCT Kalender.Monat,','))"},

[rwunderlich]

Each month in the list must be in single quotes. 

='''' & concat(DISTINCT Month, ''',''') & ''''

You might find it simpler to code this modifier instead as:

RollingMonth24=P(Kalender.Monat),

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[phil-ebm]

Hi 

Here are the screenshots of datamodel and error message.

Error Message

Datamodel

I removed the RollingMonth part but the error are still appears.

Regards

Philipp

[phil-ebm]

Hi Rob

Thanks for your answer. Using p(Kalender.Monat) not solved the problem.

Regards 

Philipp 

[Brett_Bleess]

Philipp, any chance you can attach a reduced/sample QVW on this one, that is likely the best way to get a solution, as it may be a bit difficult otherwise.  Generally the QVW files are most helpful in these cases.  

Regards,
Brett