Solved: Re: Please help me on below queries? - Qlik Community

durgabhavani · ‎2016-07-30

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

ramasaisaksoft · ‎2016-08-01

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

pra_kale · ‎2016-07-31

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 · ‎2016-07-31

1.

Can you expand on this?

kaushiknsolanki · ‎2016-07-31

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 · ‎2016-07-31

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 · ‎2016-07-31

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

Report Inappropriate Content · ‎2016-07-31

Hi

1. Check this Link https://medium.com/@justin_skaggs/encryption-in-qlikview-54aedfba6f0e#.ku2vkt4kw

durgabhavani · ‎2016-08-01

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 · ‎2016-08-01

Hi,

Both statements are correct.

kkkumar82 · ‎2016-08-01

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.