Hi Qlik Team,
I need your help on urgent basis .I am new in Qlik sense .I got one requirements in qliksense development. I am pasting the raw data below and Requiremnts table below .I will attached the excel file which assist you better:-
Whenever Number field is available in Low column based on that serial number should be reflect in High column.
Kindly refer the requirements table.
| Raw Data |
|
|
|
| Issue ID |
High |
Low |
level |
| 123 |
Access Point |
Number |
abc |
| 123 |
Access Point |
Type |
xx |
| 123 |
Access Point |
finding |
F3 |
| 123 |
Access Point |
Number |
def |
| 123 |
Access Point |
Type |
yy |
| 123 |
Access Point |
Finding |
F4 |
| 234 |
Reg |
xyz |
hj |
| 456 |
section |
ghy |
uk |
| 678 |
access |
dfh |
Bk |
| 123 |
Access Point |
Number |
zz |
| 123 |
Access Point |
Type |
xx |
| 123 |
Access Point |
finding |
F3 |
IN above raw data we have to create below chart :-
| Requirements |
|
|
|
| Issue ID |
High |
Low |
level |
| 123 |
Access Point 1 |
Number |
abc |
| 123 |
Access Point 1 |
Type |
xx |
| 123 |
Access Point 1 |
finding |
F3 |
| 123 |
Access Point 2 |
Number |
def |
| 123 |
Access Point 2 |
Type |
yy |
| 123 |
Access Point 2 |
Finding |
F4 |
| 123 |
Access Point 3 |
Number |
zz |
| 123 |
Access Point 3 |
Type |
xx |
| 123 |
Access Point 3 |
finding |
F5 |
