Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anshulsri
Partner - Contributor III
Partner - Contributor III

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

 

Labels (1)
4 Replies
chrismarlow
Specialist II
Specialist II

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.

anshulsri
Partner - Contributor III
Partner - Contributor III
Author

Thanks for your response Chris!!

 

But I need every Project number in different Column not in row as following:Inkedissue.PNG_LI.jpg

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.

chrismarlow
Specialist II
Specialist II

Hi,

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.
chrismarlow
Specialist II
Specialist II

So table of data (left), pivots to columns (right);

20190312_2.png

Then a selection reduces the columns;

20190312_3.png