Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
durgabhavani
Creator III
Creator III

Please help me on below queries?

Hi All,

Please advice me on below queries

1. Can we load encrypted data into qlikview?. If so how data can we see data?

2. How to load 50 GB of data into qlikview and how to check whether the data loaded successful?

3. What is difference between below two statements?

Store emp into emp.qvd;

Store emp into emp.qvd (qvd);

Thanks,

Govind Raju D

1 Solution

Accepted Solutions
ramasaisaksoft

Hi Durga,

1. Can we load encrypted data into qlikview?. If so how data can we see data?


No It is no't possible.


As per your replies, you can't load the same encrypted  data into qlikview as a meaning full data(No reporting tool have the capability to decry pt the data in a meaning full way )


2. How to load 50 GB of data into qlikview and how to check whether the data loaded successful?


Load data in QVD Format.


you can confident the data loaded 50 GB, when you cross verify your data (Count of Records in Each table)




3. What is difference between below two statements?


Store emp into emp.qvd;

         (Vs)

Store emp into emp.qvd (qvd);


-->  both are do the same when you are saving the data into qvd format.


View solution in original post

10 Replies
pra_kale
Creator III
Creator III

Hi,

on point 3.

What is difference between below two statements?

Store emp into emp.qvd;

Store emp into emp.qvd (qvd);

As far as my knowledge, if you want to store the out put into qvd then you can use either of the two statement. As both statement gives you the same out-put. But, when you want to import data from qvd in to qlik then at that time by default qlik assigns (qvd) in front of imported QVD. It is must else qlikview will not recognise the file type and gives a error message.

Experts can guide further..

robert_mika
Master III
Master III

1.

Can you expand on this?

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

HI,

1. Can we load encrypted data into qlikview?. If so how data can we see data?


QlikView do not decrypt the Data by its own, it will load the data in same format as the source.

This is because there are various encryption algorithm available and its difficult to understand what algorithm is used. And BI tool is not designed for that.

2. How to load 50 GB of data into qlikview.

The data loading of 50 GB is same like any other data. All you need to make sure that you only load the data (Fields and Table) which is required for analysis. You should not load the data which is not required, because the size of the data has direct relation with the RAM requirement.

how to check whether the data loaded successful?


You can check the record count to make sure that the data is loaded or not. Also you can check the sum of Quantitative field and check with source data and check.

Regards,

Kaushik Solanki


Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
durgabhavani
Creator III
Creator III
Author

Solanki,

Thanks for reply. I am not planning to encrypt the data, I want to load already encrypted data into qlikview?

Can we do that? what will happen if I load the encrypted data into qlikview?

Can any one please allobrate below question as well?

What is difference between below two statements?

Store emp into emp.qvd;

Store emp into emp.qvd (qvd);

Anil_Babu_Samineni

Store emp into emp.qvd;

--- Here, We just send the Tables to Path

Store emp into emp.qvd (qvd);

--- Here, While fetching before table data you need to select File Type should qvd radio button / Else you will not getting any data from the path.


Good Luck

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable

durgabhavani
Creator III
Creator III
Author

I haven't found any difference with two qvds using below statements.  i am able to see the both qvds when I am selecting the file type as qvd or table files.  please advice.

Store emp into emp.qvd;

Store emp into emp1.qvd (qvd);

prabhas277
Creator
Creator

Hi,

Both statements are correct.

kkkumar82
Specialist III
Specialist III

Hi Durga,

As per knowing the store command can store data into qvd, csv, txt files so it would be good to use (qvd) after file name. It is just a caution other than that there is no difference.

Please type "store" in edit script window and press F1 on it and go through the syntax of store command.