Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have data in below manner :
Month | High | Medium | Low |
1 | 76 | 69 | 14 |
2 | 87 | 88 | 71 |
3 | 59 | 82 | 42 |
4 | 12 | 5 | 39 |
5 | 97 | 78 | 39 |
6 | 41 | 82 | 99 |
7 | 73 | 14 | 98 |
8 | 74 | 68 | 65 |
9 | 26 | 81 | 55 |
10 | 94 | 48 | 87 |
11 | 87 | 39 | 15 |
12 | 64 | 39 | 44 |
I need this to convert into a fact in below manner
Month | Type | Vaues |
1 | High | 76 |
2 | High | 87 |
3 | High | 59 |
4 | High | 12 |
5 | High | 97 |
6 | High | 41 |
7 | High | 73 |
8 | High | 74 |
9 | High | 26 |
10 | High | 94 |
11 | High | 87 |
12 | High | 64 |
1 | Medium | 69 |
2 | Medium | 88 |
3 | Medium | 82 |
4 | Medium | 5 |
5 | Medium | 78 |
6 | Medium | 82 |
7 | Medium | 14 |
8 | Medium | 68 |
9 | Medium | 81 |
10 | Medium | 48 |
11 | Medium | 39 |
12 | Medium | 39 |
1 | Low | 14 |
2 | Low | 71 |
3 | Low | 42 |
4 | Low | 39 |
5 | Low | 39 |
6 | Low | 99 |
7 | Low | 98 |
8 | Low | 65 |
9 | Low | 55 |
10 | Low | 87 |
11 | Low | 15 |
12 | Low | 44 |
How to achieve this in QV through Script ?
Thanks,
Gauraw
Hi kumar ,
Try This
K:
LOAD * Inline [
Month ,High , Medium , Low
1 ,76 ,69 ,14
2 ,87 ,88 ,71
];
kt:
crosstable (Type, Values)
load
*
Resident k;
It Works ...
Regards,
Koti
Hi kumar ,
Try This
K:
LOAD * Inline [
Month ,High , Medium , Low
1 ,76 ,69 ,14
2 ,87 ,88 ,71
];
kt:
crosstable (Type, Values)
load
*
Resident k;
It Works ...
Regards,
Koti
Hi,
Try out with below scripty & remove synthtetic Key
Directory;
LOAD Month,
High,
Medium,
Low
FROM
[New Microsoft Office Excel Worksheet.xlsx]
(ooxml, embedded labels, table is Sheet1);
Directory;
CrossTable(High, Data)
LOAD Month,
High,
Medium,
Low
FROM
[New Microsoft Office Excel Worksheet.xlsx]
(ooxml, embedded labels, table is Sheet1);
Thnaks & Regards,
Udit
Hi Kumar,
copy your data in to an excel and change the excel file path in the attached qlikview file to accomplish your task.
Regards,
Abhishek.
Hi koti,
post that we can delete the k; using drop table k , such that only required information will be there in qlikview file.
Regards,
abhishek.