Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
SORRY,
I messed the data cloud... this one is corrected!
Best regards
Fernando
Have you tested this expression in a pivot table? I Think rowNO() can´t be resolved in this kind of chart..
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.
the pivot table is just for testing the expression functionality
tRY THIS OUT!
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.
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.
SORRY,
I messed the data cloud... this one is corrected!
Best regards
Fernando