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

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

ivan_will — Sun, 02 Dec 2012 10:00:36 GMT

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!

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

swuehl — Sun, 02 Dec 2012 16:34:14 GMT

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

Hope this helps,

Stefan

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

ivan_will — Sun, 02 Dec 2012 16:59:08 GMT

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

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

swuehl — Sun, 02 Dec 2012 17:42:43 GMT

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.

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

ivan_will — Mon, 03 Dec 2012 08:11:05 GMT

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.