Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
phil-ebm
Creator
Creator

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

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. 

image.png

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

 

6 Replies
Stoyan_Terziev
Partner
Partner

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
Partner
Partner

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
Creator
Creator
Author

 

Hi 

 

Here are the screenshots of datamodel and error message.

Error MessageError Message

DatamodelDatamodel

 

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

Regards

Philipp

phil-ebm
Creator
Creator
Author

Hi Rob

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

 

Regards 

 

Philipp 

 

Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.