Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ssriramin19
Contributor III
Contributor III

restricting the data

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

12 Replies
datanibbler
Champion
Champion


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.

ssriramin19
Contributor III
Contributor III
Author

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

datanibbler
Champion
Champion

Hi,

can you maybe post your document?