topic pick() and mini chart bug in QlikView

pick() and mini chart bug

avastani — Mon, 28 Jun 2010 13:06:10 GMT

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.

pick() and mini chart bug

fernandotoledo — Mon, 28 Jun 2010 15:06:18 GMT

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

pick() and mini chart bug

avastani — Mon, 28 Jun 2010 15:19:49 GMT

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.

pick() and mini chart bug

fernandotoledo — Mon, 28 Jun 2010 15:27:35 GMT

the pivot table is just for testing the expression functionality

pick() and mini chart bug

fernandotoledo — Mon, 28 Jun 2010 15:43:16 GMT

tRY THIS OUT!

pick() and mini chart bug

avastani — Mon, 28 Jun 2010 15:46:23 GMT

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.

pick() and mini chart bug

avastani — Mon, 28 Jun 2010 17:11:40 GMT

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.

pick() and mini chart bug

fernandotoledo — Wed, 30 Jun 2010 13:55:27 GMT

SORRY,

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

Best regards

Fernando