topic Re: Exclude selection in chart dimension in QlikView

Exclude selection in chart dimension

sifatnabil — Wed, 14 May 2014 07:39:17 GMT

Hi,

How can I show all values of a field in the straight table chart dimension even if specific values of that dimension field are selected? It would be like set analysis in the dimension, where I want to exclude the field Market, i.e. <Market=,>

Re: Exclude selection in chart dimension

tresB — Wed, 14 May 2014 08:03:56 GMT

Say you have Market as Dimension, Expression=Sum(Sales). Now you re-write your expression like: =Sum({<Market=>}Sales)

Your dimension values would not respond to Market selection; you would see all Markets even one is selected.

Re: Exclude selection in chart dimension

sifatnabil — Wed, 14 May 2014 08:08:08 GMT

Thanks. As this is a straight table, instead of summing, I want to list out all the values while excluding Market. So the expression I tried is this:

=({<Market=>} FieldName)

But this is a syntax error. Is there a way to exclude Market in this expression?

Re: Exclude selection in chart dimension

varunjain — Wed, 14 May 2014 08:08:47 GMT

For the above scenario, try the below expression

=Sum({1}Sales)

Re: Exclude selection in chart dimension

tresB — Wed, 14 May 2014 08:10:49 GMT

Try like:

=Concat({<Market=>} Distinct FieldName, ',')

Note: Distinct is your choice/requirement

Re: Exclude selection in chart dimension

ashfaq_haseeb — Wed, 14 May 2014 08:11:18 GMT

Write below expression

=Sum({<Market=>}Sales)

And go to presentation tab and hide your expression. hide expression.

Regards

ASHFAQ

Re: Exclude selection in chart dimension

varunjain — Wed, 14 May 2014 08:14:35 GMT

If you want that nothing should change the straight table then try =sum({1} FieldName) instead of =sum({<Market=>} FieldName)