Make an anonymous export

[#1]

Hello,

I would like to know how I can make an anonymous export of my qlikview data without scrambling the data. One of our customers wants to receive a copy of the Qlikview file every month. The Qlikview file contains a lot of end user data and the customer should only be able to access the data at a certain aggregation level based on the first two numbers of the postal code of the end user. Scrambling the data is no option, because the postal code information would also be scrambled. How can I fix this?

[martinpedersen]

Do you need to send the qlikview file or just a export from a chart? If its the latter case just select the needed postal codes and then export the table? If you need to send the Qlikview file - then you could use section access, partial reload, a criteria in the load script or just rigth join with the needed postal numbers in the end of the table? And then export that file?

Could you please provide some more details about the what you need?

[Michiel_QV_Fan]

Untested:

Create a subfield from the postal code. (left(postelcode,2) as selector

Select the appropriate postal code in your application.

Reduce data to selected values only. (File / Reduce Data)

Save the app, test the results, and sent it to your customer.

Hope this helps.

Regards

Michiel

[#4]

I need to export the complete file.

[#5]

Hello Michiel,

I need the data for all postal codes. Your solution reduces the amount of data and does not remove the accompanying address data.

[martinpedersen]

Then make a copy of you first document (perhaps replace the script with a binary reload of the first file) and then make a right join in the end with a table that only match your criterias for the export file?

[Michiel_QV_Fan]

I agree with Martin.

Create a second version document with data limited to the specific data for this customer.

Are you sure about the scrambling option? Every field can individualy be selected for scrambling.

You can reload the postal code field again as a customer specific field (limited with criteria as Martin suggest) and scramble the original postal code field.