Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can show excluded (non-selected) companies in a text box using set analysis:
=concat({1-$} Company, ', ')
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 ...
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.
Works for me - see attached