topic Restrict field selections on charts in QlikView

Restrict field selections on charts

bhaskarsharma03 — Thu, 26 Jun 2014 05:58:03 GMT

Hi,

Can anyone suggest how can I make my chart react to field selections only on some predefined fields? It shouldn't be changed by selections on other fields.

For example, I have some 20 dimensions available for users to select from, but I want my chart to respond to only 2 of the dimensions, for rest of the dimensions it shouldn't respond.

Please refer to the attached sample application.

Regards,

Re: Restrict field selections on charts

Thu, 26 Jun 2014 06:13:57 GMT

then use Alternate states. Assign a different alternate state to all those 18 list boxes.

Re: Restrict field selections on charts

Thu, 26 Jun 2014 06:14:27 GMT

or assign a different alternate to the 2 list boxes and make sure your chart has "that" alternate state as well.

Re: Restrict field selections on charts

aveeeeeee7en — Thu, 26 Jun 2014 08:02:36 GMT

Hi Bhaskar

Try this in your expression:

sum({<$(=concat({1<$Field-={'Country','ID'}>} '[' & $Field & ']=',','))>} Amount)

The fields used in the expression will give you the result on their Selections. Rest all other fields are excluded.

Hope that works for you.

See the Attachment.

Regards

Aviral