topic Re: Please help me on below queries? in QlikView

Please help me on below queries?

durgabhavani — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Please help me on below queries?

pra_kale — Sun, 31 Jul 2016 05:50:00 GMT

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..

Re: Please help me on below queries?

robert_mika — Sun, 31 Jul 2016 07:15:53 GMT

Can you expand on this?

Re: Please help me on below queries?

kaushiknsolanki — Sun, 31 Jul 2016 07:41:15 GMT

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

Re: Please help me on below queries?

durgabhavani — Sun, 31 Jul 2016 11:37:44 GMT

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);

Re: Please help me on below queries?

Anil_Babu_Samineni — Sun, 31 Jul 2016 11:54:21 GMT

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

Re: Please help me on below queries?

Sun, 31 Jul 2016 13:01:30 GMT

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

Re: Please help me on below queries?

durgabhavani — Mon, 01 Aug 2016 05:36:20 GMT

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);

Re: Please help me on below queries?

prabhas277 — Mon, 01 Aug 2016 06:39:43 GMT

Hi,

Both statements are correct.

Re: Please help me on below queries?

kkkumar82 — Mon, 01 Aug 2016 07:10:50 GMT

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.

Re: Please help me on below queries?

ramasaisaksoft — Mon, 01 Aug 2016 07:50:11 GMT

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.