How to load a sub-set of data

[#1]

Hi to all,

I have a set of data named "Options" and another sub-set of this named "HVoptions" how can I load into Qlikview those two sets of data to make possible the selection of only "HVotions" values?

Many thanks!

[Miguel_Angel_Baeyens]

Hi,

If you mean loading in the script only some records from a give source, use the WHERE clause in either the LOAD or the SQL (if possible). That may vary largely depending on your data source and complexity, but in short:

Table:
LOAD *
FROM File.qvd (qvd)
WHERE Field = "HVOptions";

If you want to show only those values in a chart, use a set analysis in the expression:

Sum({< Field = {'HVOptions'} >} Value)

Hope that helps.

Miguel

[vijay_iitkgp]

In Addition to Miguel If you want to  load both tables and want to keep all the data from Options  that is available in HVOptions then you can use following Code.

HVOptions:

Load

*

From Options;

Left Keep

Load

*

From Options.

Hopr this will help.