topic Re: Creating a fact in QV in QlikView

Creating a fact in QV

Wed, 27 Nov 2013 06:50:06 GMT

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

Re: Creating a fact in QV

Wed, 27 Nov 2013 07:15:55 GMT

Hi kumar ,

Try This

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

Re: Creating a fact in QV

udit_kumar_sana — Wed, 27 Nov 2013 07:32:50 GMT

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

Re: Creating a fact in QV

Wed, 27 Nov 2013 07:52:39 GMT

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.

Re: Creating a fact in QV

Wed, 27 Nov 2013 08:00:20 GMT

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.