Mini Chart does not work with ValueList and Set Analyses!? /file is attached

[ivan_will]

Hi all,

I have a serious problem with the valuelist and the mini chart expressions in str table.

So The expression for the minichart does not recognize the set analyses! and so all the mini charts chrashed when you have a selection on month ot a year (dim for the minicharts is Month)

Please see the attached file! So When you select a value from the F1 fields everything goes wrong ...

So please help!

[swuehl · Accepted solution]

Maybe like this, using an alternate state and slightly modified expression?

Hope this helps,

Stefan

[ivan_will]

Stefan, could you please explain me what changes with that Alternative state? It is working but why?

[swuehl]

Not sure if I can answer this question, since I would have expected your original version to work also.

I think the issue arise from the use of the valuelist() function. I noticed that changing your original version's expression to

=pick(match(only({1} ValueList('First', 'Second', 'Third','4','5')), 'First', 'Second', 'Third','4','5'),

sum({ <F1=>} F2),

avg({ <F1=>} F3),

sum({ <F1=>} F4),

sum({ <F1=>} F2),

sum({ <F1=>} F2)

)

does the trick also, though I believe the synthetic dimension shouldn't reflect any selections anyway. Seems like a bug too me.

[ivan_will]

Yes , it seems to be a bug for me also.

And the expressions above works only for a simple reports. If you have a more complex DB and relations it crashes.

I will report it as a bug.