topic Re: I need to display Region = 'CEE' only ,but I need to display the same in all the applications(attached Emma.png) ,I attached that QVD also pls suggest how to do in QlikView

I need to display Region = 'CEE' only ,but I need to display the same in all the applications(attached Emma.png) ,I attached that QVD also pls suggest how to do

Tue, 07 Jan 2014 05:45:03 GMT

Re: I need to display Region = 'CEE' only

senpradip007 — Tue, 07 Jan 2014 05:56:11 GMT

Hi palla,

As per my understanding you want to display CEE region only.

Set OnActiveSheet trigger first, select the Region='CEE' and then lock Region field then OnLeaveSheet Unlock Region and Clear the field Region.

Hope it will help you.

Re: I need to display Region = 'CEE' only

Tue, 07 Jan 2014 07:23:44 GMT

Hi,

Not sure if I understand you correctly, there can be two scenarios:

1. You want to have only "CEE" as region in your application, in this case you can apply a filter in script on your query as:

Where region = 'CEE'

2. Another possibility, you want all the regions to be available in the application but want to show only CEE on this particular sheet, then you can add an action OnActivateSheet as below:

Action Type: Selection

Action : Select in field

Field : Give the fieldname for Region

Search String : CEE

Hope this helps!

Re: I need to display Region = 'CEE' only ,but I need to display the same in all the applications(attached Emma.png) ,I attached that QVD also pls suggest how to do

Tue, 07 Jan 2014 07:46:32 GMT

Thanks ,but reamining also will be displayed in the drop down ,here my script is there pls check

CompanyLoad:
Select
PRM.EMMA_GROUP_CODE      as EMMA_Group
,PRM.CO_ID
,PRMH.CUR_CODE
,PRM.EMMA_TRSF_COST_GRP
,PRM.EMMA_CGM_GRP
,PRM.EMMA_ELNSP_GRP
,PRMH.EMMA_RPT_UNIT
,PRM.EMMA_INVC_SRC
,SLLR.GEDW_TRP_KEY
,PRM.EMMA_REGION_NAME
,PRM.CO_NAME

from     DEALLV01.PR_EMMA_PARMS_V001                         PRM
     join DEALLV01.PR_EMMA_PARMS_V001                         PRMH
       on PRM.EMMA_GROUP_CODE = PRMH.EMMA_GROUP_CODE
      and PRMH.CO_ID = '**'
     join dcsav01.vcsa_trading_partner_location               sllr
        on prm.sllr_loc_id = sllr.tp_loc_id
           and sllr.tp_loc_qlfr_code = 'FC'
           and sllr.tp_curr_ind      = 'Y'
Where
      PRM.EMMA_GROUP_CODE = '$(EMMAGROUP)'
      $(COMPANY)
;

Company:
left Keep (InvoiceLoad) load distinct
EMMA_Group
,CO_ID
,CUR_CODE                                            as Report_Currency
,GEDW_TRP_KEY                                        as SLLR_TRP_KEY
,EMMA_TRSF_COST_GRP
,EMMA_CGM_GRP
,EMMA_ELNSP_GRP
//,EMMA_RPT_UNIT                                       as Report_Unit
//,if(EMMA_RPT_UNIT ='FQ','Figured Quantity Units',
//       if(EMMA_RPT_UNIT ='SELL','Selling Units',
//       if(EMMA_RPT_UNIT ='SC','Supply Chain Units','Unknown Unit Requirement'))) as Reporting_Unit
,EMMA_INVC_SRC                                      as Source
,CO_NAME                                            as Company
,EMMA_REGION_NAME                                   as Region
Resident CompanyLoad;

Drop Table CompanyLoad;

Re: I need to display Region = 'CEE' only ,but I need to display the same in all the applications(attached Emma.png) ,I attached that QVD also pls suggest how to do

callsresri — Tue, 07 Jan 2014 07:49:22 GMT

pandit is right..

Re: I need to display Region = 'CEE' only ,but I need to display the same in all the applications(attached Emma.png) ,I attached that QVD also pls suggest how to do

Tue, 07 Jan 2014 07:52:11 GMT

If you want to do it at script level then in your script, you can add a filter in "Company" table as :

Where EMMA_REGION_NAME = 'CEE' and that should work.

Re: I need to display Region = 'CEE' only ,but I need to display the same in all the applications(attached Emma.png) ,I attached that QVD also pls suggest how to do

Tue, 07 Jan 2014 08:02:22 GMT

Thanks for all

Re: I need to display Region = 'CEE' only

Wed, 14 May 2014 09:09:13 GMT

I want to select APJ if OSUser()=ASIAPACIFIC\

please help