
Contributor II
2020-06-24
05:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Question regarding the field selection in qlikview
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.
592 Views
1 Solution
Accepted Solutions


MVP
2020-06-25
10:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
1 Reply


MVP
2020-06-25
10:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Take a look here: The-As-Of-Table
- Marcus
