Question regarding the field selection in qlikview

[mohanrajsubrama]

Hi Team,

I am working in qlikview for little long time but i have a requirement like below which actually iam trying.

Reqirement is there is a ID column  and there are some combined values separated with comma(1,2,23 and 2,3,5) and there is some indivdual values like 23,2,5,1 ..

ID	Cost	Profit
1,2,23	45	78
2,3,5	50	50
23	10	300
2	15	435
5	65	500
1	2	4

So when the user selects combined values they should also want their individual selection also.

For example if we select 1,2,23 then the output should be like below .

ID	Cost	Profit
1,2,23	45	78
23	10	300
2	15	435
1	2	4

if they select only 23 then the output should be like below.

23

10

300

Kindly please help how do we acheive this scenario.

Thanks in advance,

Mohan.

[marcus_sommer · Accepted solution]

Take a look here: The-As-Of-Table 

- Marcus