pick() and mini chart bug

[avastani]

Has anyone faced a problem with using the pick() function with a mini-chart representation?

For some odd reason, QV only selects the first expression of the pick() list of expressions as the one to be plotted as a mini chart as opposed to a different one. For instance, my Dimension is Metrics with a list of 10+ metrics. The expression is PICK(rowno(), expression1, expression2, .., expressionN) with a mini chart representation over MonthYear time dimension. The textual representation of this expression works out just fine but the the mini chart does not.

Any help is greatly appreciated, thanks.

[fernandotoledo]

Have you tested this expression in a pivot table? I Think rowNO() can´t be resolved in this kind of chart..

[avastani]

i cannot use a pivot table since one cannot use mini-charts in a pivot table except for straight tables.

the only workaround i have is a nested-if but that mounts to 28+ nested ifs which isn't really sensible and slows down the sheet refreshes for every click, even if i broken the table into smaller tables or 2-4 expressions.

[fernandotoledo]

the pivot table is just for testing the expression functionality

[fernandotoledo]

tRY THIS OUT!

[avastani]

the expression works in a pivot and straight table so long as they are text representations and not mini-charts. i tihnk it is only plotting number 1 in the mini-chart and nothing else.

[avastani]

This certainly works but only because the expression number is connected in the datamodel. My case is to use an island table where it falls apart. I put yours into an island and tried it and it worked but didn't in mine. I also have blank space rows which have no expression for the mini-chart so I am guessing that's where it falls apart.

[fernandotoledo · Accepted solution]

SORRY,

I messed the data cloud... this one is corrected!

Best regards

Fernando