topic Re: Storing data of a selection into new qvd in QlikView

Storing data of a selection into new qvd

Anonymous — Wed, 05 Apr 2017 10:09:54 GMT

Hi everyone,

is there a possibility to store the data of a selection (out of multiple list boxes) into a new qvd file?

Example:

1. I'm loading a huge amount of data into qlik

2. I'm then performing some selections / filters on the data via list boxes

3. I want to store the selected data into a new qvd file

I found this discussion earlier but am not quite sure if that is really what need?

Storing selection into qvd

Thank you

felipe flamenco

Re: Storing data of a selection into new qvd

ahaahaaha — Wed, 05 Apr 2017 11:29:11 GMT

Hi,

If I understand you correctly, your plan can be fully implemented, only after the selections in objects of your sheets the data will to be saved in the format QVO.

Regards,

Andrey

Re: Storing data of a selection into new qvd

ahaahaaha — Wed, 05 Apr 2017 11:31:36 GMT

Look here QVD files ‒ QlikView

and here Export/Export Contents... ‒ QlikView

Re: Storing data of a selection into new qvd

Anonymous — Wed, 05 Apr 2017 11:55:49 GMT

Hi Andrey,

thank you. That's not exactly what I need. It looks like this function is only the selected values. What I am looking for is the following:

I am selecting data. Based on the selection, I want to keep only the selected data and store it into a new qvd so that I can then load the selected / reduced data into a new qvw document.

Re: Storing data of a selection into new qvd

ahaahaaha — Wed, 05 Apr 2017 12:02:04 GMT

If do the selection in direct tables and further is stored in QVO file, then this files can also be downloaded to another database Qlik.

Re: Storing data of a selection into new qvd

ahaahaaha — Wed, 05 Apr 2017 12:10:04 GMT

Прикрепленный файл 16.qvw - начальная база данных с выбором CSE в поле LOB. Файл 1.qvo - экспорт выбранных данных. Файл 16_1.qvw - загрузить данные из 1.qvo.

Re: Storing data of a selection into new qvd

stabben23 — Wed, 05 Apr 2017 12:11:17 GMT

Hi,

if it is a datamodel this is not possible, if you only use one table you can create variables and then use it in Your where statement in the Next reload.This can be a tricky one.

If you have a datamodel then you can use File-->Reduce Data--> >Keep possible value and save the qvw to a "New qvw" with selected data. Then load the "New qvw" binary into another New qvw. This is very much manual but this will work.

Re: Storing data of a selection into new qvd

Anonymous — Mon, 10 Apr 2017 09:24:36 GMT

Hi Staffan,

sounds quite satisfying to me. But how do I load the "new qvw" binary into a new qvw?

Thank you & cheers

Re: Storing data of a selection into new qvd

Anonymous — Mon, 10 Apr 2017 09:25:24 GMT

Thank you Andrey.

unfortunately, I am not able to read Cyrillic. 🙂

Regards

Re: Storing data of a selection into new qvd

stabben23 — Mon, 10 Apr 2017 09:35:31 GMT

Hi,

when you have saved Your reduced copy, in this case as New_qvw, do this:

Re: Storing data of a selection into new qvd

Anonymous — Wed, 12 Apr 2017 10:51:12 GMT

Hi,

attached please find my solution which is similar what is described in Storing selection into qvd

Settings -> Document Properties -> Triggers -> Variable Event trigger -> V1 -> OnChange -> Add Action -> Set Veriable -> V2 -> Value: =V1

Thanks all for your help!

Re: Storing data of a selection into new qvd

Anonymous — Thu, 13 Apr 2017 14:28:34 GMT

Hi again,

next challenge:

Do you know how I can separately store the selected and not selected data into a new qvd. file?

I could first store the selected data and then hit "select excluded" and store the new selection. How can I reflect this in the script so that Qlik is storing it into a new file name?

Thank you