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: 
Not applicable

Displaying unselected items

hi,

i am jsut wondering if anyone could help me with a problem. currently i am working on a small project on Qlikview. there is a company list and also project list. when ever you make a selection on type of project and project name it should display all the data related including the companies involved with that project. now when i make the selection to show companies i also want to show non-participating companies along with the participating ones.

i just dont have any idea on how to do this. I am just hoping someone to help me with this.

4 Replies
Anonymous
Not applicable
Author

You can show excluded (non-selected) companies in a text box using set analysis:
=concat({1-$} Company, ', ')

Not applicable
Author

hi i tried using that in a text box ... first it says error in expression and second i want to show participating and non-participating companies together in a text box or pivot or straight table along with other data i mentioned in my query ...

Not applicable
Author

Only List Boxes retain non-selected values, but a list box only shows a single field. Using the text box means the data shown is not subject to the behaviour of selections in Table objects. You may be trying to do something that is not possible.

Is there a specific reason you want to display the companies as you describe? There may be a different way to get the display you want by solving the problem differently.

Anonymous
Not applicable
Author

Works for me - see attached