Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Try this:
RollingMonth24={"$(=Concat(DISTINCT Kalender.Monat,','))"},
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
Hi
Here are the screenshots of datamodel and error message.
I removed the RollingMonth part but the error are still appears.
Regards
Philipp
Hi Rob
Thanks for your answer. Using p(Kalender.Monat) not solved the problem.
Regards
Philipp
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