topic Re: List box selection not reflected in chart in QlikView

List box selection not reflected in chart

Fri, 21 Mar 2014 08:27:43 GMT

This is probably a stuppid question, but I have a chart with two dimensions (weekstart and Market)

My expression is very simple (i have substituted the real name of my summed field with XXXXX)

=SUM({$<Market={'APAC*'}>}XXXXX/1000)

When I select one of the 3 markets, the chart does not change. However, when I select any other value in any other list box the chart changes accordingly.

Why is this 'Market' field different?!

Re: List box selection not reflected in chart

kji — Fri, 21 Mar 2014 08:55:51 GMT

$<Market={'APAC*'}> in your expression means you are ignoring selections in market and treating it as if APAC is selected. Look up "Set analysis" for more information.

Re: List box selection not reflected in chart

CELAMBARASAN — Fri, 21 Mar 2014 09:21:27 GMT

If you want to do so you could use this

=SUM({$*<Market={'APAC*'}>} XXXXX/1000)

there is a asterisk in between $ and <.

Re: List box selection not reflected in chart

ThornOfCrowns — Fri, 21 Mar 2014 09:23:09 GMT

Could you explain the significance of the * ?

Re: List box selection not reflected in chart

Fri, 21 Mar 2014 09:23:09 GMT

Thanks Celambarasan!

Re: List box selection not reflected in chart

CELAMBARASAN — Fri, 21 Mar 2014 09:24:32 GMT

It results you the Intersection between the selection($) and the set analysis conditions.

Re: List box selection not reflected in chart

ThornOfCrowns — Fri, 21 Mar 2014 09:29:12 GMT

Always helpful to show your working out for others who come to the thread!