Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

Field Level Trigger Variables table driven

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
20 Replies
sujeetsingh
Master III
Master III

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

vikasmahajan
Author

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
vikasmahajan
Author

Is there any way to achieve the same  ?

Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Kushal_Chawda

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

Not applicable

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
Author

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
vikasmahajan
Author

Thanks Khushboo ,

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

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Kushal_Chawda

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

vikasmahajan
Author

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.