Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
subbareddykm
Creator II
Creator II

Need help?

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

1 Solution

Accepted Solutions
nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

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

View solution in original post

5 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

Not applicable

Hi reddy,

find the following link

How to create Qvd ?

Not applicable

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

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

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

subbareddykm
Creator II
Creator II
Author

Ok,thanks for the response.

let me check.