topic Re: Need help? in QlikView

Need help?

subbareddykm — Fri, 20 Nov 2020 18:02:30 GMT

Hi all ,

Can any one tell me how to achieve this ?

I want to convert data to QVD like >>

KPI Name ,Company, Year , HalfYear ,quarter ,Value ,Flag.

>>In KPI Name all KPI Names,

>>Company All Company Names i.e XYZ,XYZ1 and XYZ2

>>Half Quarter i.e H1 and H2 should be link with Quarter.

><Quarters i.e Q1,Q2,Q3 Q4 and Years

>> Values should be match with all.

my QVD should be present Like

KPI Name,

Compant,

Year,

Quarter

Value

Flag

Re: Need help?

Peter_Cammaert — Fri, 18 Dec 2015 13:54:36 GMT

Create a QVW document. In your load script, create an internal table with all the required rows and columns. Then perform a STORE of this internal table to QVD. That's about all you need to do.

Best,

Peter

Re: Need help?

Fri, 18 Dec 2015 14:03:19 GMT

Hi reddy,

find the following link

How to create Qvd ?

Re: Need help?

Fri, 18 Dec 2015 14:05:46 GMT

I possiable to share any excel file or total dimensione of that table

Re: Need help?

nagarjuna_kotha — Fri, 18 Dec 2015 14:56:57 GMT

Hi,

I have seen this post yesterday ,

Create QVW

CRTL +E ,Click on tables select your File and If you want click o next and transpose there you see various options in that.Change based on your requirement.

If you dont want any transpermations simply select file and Finish it.

-Nagarjuna

Re: Need help?

subbareddykm — Fri, 18 Dec 2015 15:00:20 GMT

Ok,thanks for the response.

let me check.