Field Level Trigger Variables table driven

[vikasmahajan]

Hi,

I have field level trigger  on %initiative  field ( On Select & On Change) following is my code , Is there any possibility whether we can store this values into table/excel and load into  field trigger automatically ?

= if(Initative='Backup Decom - Non PROD'	,'[NonPrdBkp.Hostname]',
if(Initative='Backup Decom - PROD'	,'[BackupProd.Hostname]',
if(Initative='SAN ReTier - DEV'	,'[SANReTier.HostKey]',
if(Initative='SAN ReTier - Non DEV'	,'[SANReTierNONDEV.HostKey]',
if(Initative='Server Decom'	,'[ServerDecom.HostKey]' ,
if(Initative='Decom Server Charges'	,'[DComServer.HostKey]' ,
if(Initative='NAS ReTier - DEV'	,'[NASReTierDEV.HostKey]' ,
if(Initative='NAS ReTier - Non DEV'	,'[NASReTierNonDEV.HostKey]' ,
if(Initative='VSI Low Util'	,'[VSILowUtil.HostKey]' ,
if(Initative='Stale Job Decom'	,'[StaleJobDecomDEV.HostKey]' ,
if(Initative='Virtualization Resize'	,'[VirtualizationResize.HostKey]' ,
if(Initative='Cluster Reduction'	,'[ClusterReduction.HostKey]' ,
if(Initative='High RTO RPO To SAN Standard'	,'[HRR_To_SAN_Std.HostKey]' ,
if(Initative='SAN Dev To NAS'	,'[SanDevToNAS.HostKey]' ,
if(Initative='SAN QA To NAS'	,'[SanQAToNAS.HostKey]' ,

  if(Initative='SAN UAT Premium To SAN Standard' ,'[SanUATPrmToSANStd.HostKey]' ,

if(Initative='SAN Rightsize File Systems'	,'[SAN_RightsizeFileSystems.HostKey]' ,
if(Initative='NAS - Zero Utilized'	,'[NASZeroUtilized.HostKey]' ,
if(Initative='NAS Underutilized'	,'[NASUnderutilized.HostKey]' ,
if(Initative='Zero IO SAN'	,'[ZeroIOSAN.HostKey]' ,
if(Initative='Unused Databases'	,'[UnusedDatabases.HostKey]' ,

  if(Initative='RTO Greater Than 48 Remove DR'   ,'[RTOGR48REMDR.HostKey]' ,

if(Initative='DB Dumps To NAS'

,'[DBDumpsToNAS.HostKey]' ,

)))))))))))))))))))))))

Thanks

Vikas

[sujeetsingh]

I think you can use the External action or may be a macro to implement this.

[vikasmahajan]

Hi,

Thanks I need some thing  because today this are 20 opportunity in feature it can be 100's  that time it will difficult to maintain in code !

Vikas

[vikasmahajan]

Is there any way to achieve the same  ?

Thanks

Vikas

[Kushal_Chawda]

I did not understand what do you mean by automatically, if new Initative comes you need to define that condition manually.

[#6]

I had this requirement earlier in my project.

Researched a lot but couldn't find any solution that time.

I do not think this is feasible in Qlik.

[vikasmahajan]

Hi,

Kush I have vInititiavtiveHost and dynamically in field level trigger we are storing values to vInititiavtiveHost variable

now approximate 20 opportunity we have done using this logic by putting in script as i attached screen short , Now whether Can i put all if expressions into table or excel and import the same and assign to field level trigger ?

Hope you understand my requirement now

Vikas

[vikasmahajan]

Thanks Khushboo ,

I think there should some thing we can do using dynamic logic.

Vikas

[Kushal_Chawda]

what is the purpose of field event trigger here? Can you explain with example?

[vikasmahajan]

In drop down box , we display 20 opportunity , When user select opportunity like for e.g.Back Decom Non Prod , then related to that opportunity all data is display in pivot table along with lot of information related to that opportunity . Like this we have design for 20 opportunity. when user select opportunity we are storing values into variables using field level trigger , Now I want to put all this code into excel or table & want to load into field level trigger variables .

Please let know any additional details you require .

Thanks

Vikas