Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
sifatnabil
Specialist
Specialist

Exclude selection in chart dimension

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=,>

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

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

Note: Distinct is your choice/requirement

View solution in original post

6 Replies
tresesco
MVP
MVP

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.

sifatnabil
Specialist
Specialist
Author

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?


varunjain
Creator
Creator

For the above scenario, try the below expression

=Sum({1}Sales)

tresesco
MVP
MVP

Try like:

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

Note: Distinct is your choice/requirement

ashfaq_haseeb
Champion III
Champion III

Hi

Write below expression

=Sum({<Market=>}Sales)

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

Regards

ASHFAQ

varunjain
Creator
Creator

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