Select predefined fields from a qvd

prifgian — Sat, 16 Nov 2024 02:22:13 GMT

I would like to select some fields from a table that I have defined in another table.

For example, I have the following Excel:

Field	TableQVD
Fecha	Both
nro_ficha	Both
temp_agua	States
temp_aceite_motor	States
prioridad	Definitions

LOAD
Field,
TableQVD
FROM [\\Tiempo datos qlik.xlsx]

What I need to do is based on the data in this table, to select from 2 qvd (States and Definitions) that have many fields, only the fields that appear in the table accorrding to the clasification.

That is, from Definitions.qvd just select the fields Fecha, nro_ficha and prioridad. And from States.qvd select the fields nro_ficha, temp_agua and temp_aceite_motor.

I need the Excel because the fields that I have to select will vary over the time, and the people who decide wich ones are going to be selected are from another deparment.

Thanks!

Re: Select predefined fields from a qvd

Brett_Bleess — Tue, 08 Oct 2019 13:29:16 GMT

about the best I have is probably only part of the solution, but hopefully helps you with that aspect of things, and I am including the base Design Blog link, so you can use that to search all the other posts out there on the other aspects I have not hit upon, I believe you should be able to find lots of different examples on how you might go about things in this case.

https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

This will also kick things back to the top of the list too, so maybe someone else will have another look and have some other ideas, sorry I am not more help.

Regards,
Brett

topic Re: Select predefined fields from a qvd in QlikView

Select predefined fields from a qvd

Re: Select predefined fields from a qvd