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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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.