Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create multiple pie charts on one sheet. Each pie chart will contain a subset of the overall data I am trying to display with conditional expressions, however I am running into issues.
One of the pie charts I am trying to create should show the number of SKU's based on the following SKU_MODEL however, when I enter this into the conditional portion of the expression it shows all SKU Models, not just the one. What am I doing wrong?
=Count({$<SKU_MODEL={"CIS"}>}DISTINCT(MATNR))
=Count({$<SKU_MODEL={'CIS'}>}DISTINCT(MATNR))
Do single quotes work?
No, that does not work either.
This is how I am using the expression.
Your Expression works. But not sure where you are writing..Seems you are writing in Conditional show box.
Conditional boxes will take just TRUE/FALSE statements.
Write you expression in "Definition box" ... Refer attached.
Thanks for the help. However I am still having problems in that I am using a multi box to do some additional filtering of the data. However it seems that the multi box is not affecting the chart with the conditional expression. Why is this happening?
Can you post a sample?
Here are screenshots.
No filter
With Filter
No change when I selected filters.
Are you using alternate states? if then in order to work based on your selection on multibox, you have to make sure both objects has the same state.
you can check by right clicking and going to properties of the object and see under general tab. right after window title..
Alternate states drop down will appear only if you created at least one in document properties.
They are both using the same alternate state.
Hmmm... Not sure what is happening then...
It will be really helpful if you can share the sample QVW file with me..i will take a look into it...