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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register 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
vikasmahajan
Author

Hello Jon,

Related this issue i am trying this following 

Loading Fields as variables ( Data Model)

Also i have modified qvw and requirement details in thread can you please guide me ?

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.