topic Triggering Expression Value in the field in to dimension in QlikView

Triggering Expression Value in the field in to dimension

anshulsri — Sat, 16 Nov 2024 21:16:10 GMT

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

Re: Triggering Expression Value in the field in to dimension

chrismarlow — Mon, 11 Mar 2019 20:38:34 GMT

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.

Re: Triggering Expression Value in the field in to dimension

anshulsri — Tue, 12 Mar 2019 06:21:20 GMT

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.

Re: Triggering Expression Value in the field in to dimension

chrismarlow — Tue, 12 Mar 2019 12:25:01 GMT

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.

Re: Triggering Expression Value in the field in to dimension

chrismarlow — Tue, 12 Mar 2019 20:17:26 GMT

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

Then a selection reduces the columns;