topic Excluding bar chart from selections in QlikView

Excluding bar chart from selections

pauldamen — Thu, 01 Mar 2012 08:40:17 GMT

Hi,

I have a stacked bar chart which has an expression which looks like this:

count ({<NPS = {'1'}>}[NPS])

Now this is a total bar chart used as an benchmark and should not change with the selection (the same bar chart is next to it which does change so you always have the comparison). Now my questions is: how can I prevent the bar chart to change with the selections?

Thanks for your help!

Regards,

Paul

Excluding bar chart from selections

Thu, 01 Mar 2012 08:43:27 GMT

Hi,

try using

count ({1<NPS = {'1'}>}[NPS])

Regards

Przemek

Excluding bar chart from selections

CELAMBARASAN — Thu, 01 Mar 2012 08:46:43 GMT

Hi,

Using 1 will excludes the all field selections.

=count ({1<NPS = {'1'}>}[NPS])

Celambarasan

Excluding bar chart from selections

nilesh_gangurde — Thu, 01 Mar 2012 09:23:59 GMT

Hey ,

Try this one:

=count({<Field_name1 =,Field_name2,NPS ={'1'} >}[NPS])

Where Field_name1 and Field_name2 is the name of the fields which u want to avoid the selections.

Hope this will help you.

Regards,

Nilesh Gangurde

Excluding bar chart from selections

jagan — Thu, 01 Mar 2012 09:54:45 GMT

Hi,

For excluding all the selections use this expression

=count ({1<NPS = {'1'}>}[NPS])

For excluding particular expressions, specify fields to exclude with =

=count ({ <FieldName1=, FieldName=2, NPS = {'1'}>}[NPS])

Hope this helps you.

Regards,

Jagan.

Re: Excluding bar chart from selections

sridhar240784 — Thu, 01 Mar 2012 10:07:08 GMT

Hi,

Additional info, if you want to exclude all the fields except FieldName3, FieldName4. You may try below code.

Sum ({<NPS = {'1'},$(=Concat(if(Not WildMatch($Field, 'FieldName3',''FieldName4'','NPS'),$Field),'=,')&'=')>} NPS)

Attached is an example.

-Sridhar

Excluding bar chart from selections

pauldamen — Thu, 01 Mar 2012 10:20:57 GMT

Thanks a lot to all of you! It works!