topic Re: restricting the data in QlikView

restricting the data

ssriramin19 — Mon, 26 Jan 2026 18:19:17 GMT

In my application there is some thing called level of analysis (LOA_DESC) . with the values country and purchasing country,

When country is selected following appears in the report (attached with the file name country level of analysis) As can be seen from the image for the country only ar:argentina br:Brazil should apprear.

How to filter those other values when country level of analysis is clicked

In other words for the country level of analysis only country code and country_desc should appear in the report.

Next for other level of analysis purchasing country only country code and cust_id should be appearing . Attached image will explain clearly .

For purchasing country there should not be any description to be appearing in the report.

The script written in the back end is

select distinct cust_id as LOA , tp_ctry_code||':'|| cust_id as LOA_DESC
from dgdmrv07.VGDMR_FPM_ADQ where dmd_mgmt_ownr_code='P401'
;
concatenate

select DISTINCT ctry_code as LOA , ctry_code||':'||ctry_desc as LOA_DESC
from dgdmrv07.FPM_LA_PROD_DTLS

Help is required at the earliest. This needs to be completed by today itself.

Thanks

Sriram

Re: restricting the data

ssriramin19 — Tue, 19 Nov 2013 11:13:11 GMT

Can anyone please help me to resolve the problem at the earliest.

Re: restricting the data

datanibbler — Tue, 19 Nov 2013 11:19:52 GMT

Hi Sriram,

maybe I am overlooking the actual difficulty - but to me it seems that just conditionalizing the dimension(s) and formula(s) of your diagram (dependent on variables) would do the job?

HTH

Best regards,

DataNibbler

Re: restricting the data

ssriramin19 — Tue, 19 Nov 2013 11:22:33 GMT

Can you please bried me on this ?

Re: restricting the data

Tue, 19 Nov 2013 11:22:50 GMT

Hi,

Do you have a link between the level you choose and what you want to display (country code & desc) ?

Fabrice

Re: restricting the data

ssriramin19 — Tue, 19 Nov 2013 11:26:36 GMT

in the back end the field everything is mapped with the same qlikview name.

Re: restricting the data

datanibbler — Tue, 19 Nov 2013 11:27:23 GMT

Hi,

as Aunez states, the data_tables have to be linked.

(Hit Ctrl+T to view the table_structure and see whether that is the case)

If you have that, then you can make the dimension(s) and formula(s) of your diagramm dependent on those selections using the GETFIELDSELECTIONS() function, for example.

Re: restricting the data

ssriramin19 — Tue, 19 Nov 2013 11:31:22 GMT

Please brief on the request and changes to be done further

Re: restricting the data

Tue, 19 Nov 2013 11:32:39 GMT

Can you upload an image of the data model ?

Because I do not see any link between country level of analysis and the country code. Not in the LOAD statements you have written.

If there is a link, the QV association will do the limit for you between the listbox (containing the country level of analysis) and the country codes in the graph/table.

Fabrice

Re: Re: restricting the data

ssriramin19 — Tue, 19 Nov 2013 11:37:21 GMT

Please find the attached data mapping (data structure) . The item master is the main table in the report. The loa_desc is the table with fields loa and loa_desc .

Re: restricting the data

datanibbler — Tue, 19 Nov 2013 11:44:33 GMT

Well, that looks good.

The two tables are linked, so any selection you make on the field LOA influences the available data from the Item_Master.

The rest is easy: In any chart_type, you can make the dimension(s) and formula(s) dependent on either variables or, e.g., the output of GETFIELDSELECTIONS(). => You can easily have one set of formulas (y-axis of your chart) displayed when LOA_#1 is selected and a different set when LOA_#2 is selected.

Re: Re: restricting the data

ssriramin19 — Tue, 19 Nov 2013 11:52:20 GMT

I am not able to get the required output after trying your approach.

Re: restricting the data

datanibbler — Tue, 19 Nov 2013 12:27:18 GMT

Hi,

can you maybe post your document?