- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Triggering Expression Value in the field in to dimension
Hi All,
I have multiple Project ID in a string separated by a delimiter. For example:
7723;4321;5433;1231;1123
We need all the Project IDs in different columns one project ID per column.So here,I have spitted this field using Subfield in 7 expressions(Each string contains 7 Project ID).Now the requirement is ,if we click on some project Number only one project number should be selected and same value should be set in the Project_ID field which contains all the project numbers.
But when I tried to select one value whole row is getting selected and all the Project ID are getting selected.
How can we get rid of this issue.
Any help is very much appreciated.
Thanks,
Anshul
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
QlikView selections work within fields, so don't you need to rework your data so Project ID is a column with those as values?
Project ID
7723
4321
5433
1231
1123
Cheers,
Chris.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for your response Chris!!
But I need every Project number in different Column not in row as following:
As shown above we have all the projects related to Customer:Deliver Channel with it in differnt columns. and as per our requirement when we select some Project only that should be selected not the other projects.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
But you would achieve that by pivoting on Project ID, where that is a column that contains your values, rather than having multiple project id columns that you seem to imply?
Cheers,
Chris.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
So table of data (left), pivots to columns (right);
Then a selection reduces the columns;