topic Re: Field Level Trigger Variables table driven in QlikView

Field Level Trigger Variables table driven

vikasmahajan — Tue, 31 May 2016 05:43:21 GMT

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

Re: Field Level Trigger Variables table driven

sujeetsingh — Tue, 31 May 2016 05:52:04 GMT

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

Re: Field Level Trigger Variables table driven

vikasmahajan — Tue, 31 May 2016 05:55:14 GMT

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

Re: Field Level Trigger Variables table driven

vikasmahajan — Tue, 31 May 2016 06:49:37 GMT

Is there any way to achieve the same ?

Thanks

Vikas

Re: Field Level Trigger Variables table driven

Kushal_Chawda — Tue, 31 May 2016 06:53:51 GMT

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

Re: Field Level Trigger Variables table driven

Tue, 31 May 2016 06:57:37 GMT

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.

Re: Field Level Trigger Variables table driven

vikasmahajan — Tue, 31 May 2016 07:07:39 GMT

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

Re: Field Level Trigger Variables table driven

vikasmahajan — Tue, 31 May 2016 07:09:08 GMT

Thanks Khushboo ,

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

Vikas

Re: Field Level Trigger Variables table driven

Kushal_Chawda — Tue, 31 May 2016 07:14:05 GMT

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

Re: Field Level Trigger Variables table driven

vikasmahajan — Tue, 31 May 2016 07:30:22 GMT

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

Re: Field Level Trigger Variables table driven

Kushal_Chawda — Tue, 31 May 2016 07:44:41 GMT

for eg .

vInitativeHost

if(Initative='Backup Decom - Non PROD','[NonPrdBkp.Hostname]',

You are storing the value in Variable [NonPrdBkp.Hostname] which is I guess the field name? rite? like wise you have created 20 Variables? Where you are using this variable?

Re: Field Level Trigger Variables table driven

jonathandienst — Tue, 31 May 2016 07:54:42 GMT

I would not use variables for this approach. As you can already see, that gets complex when you have a lot of values. I would create a table (inline or from external txt/xlsx file) that associates the opportunity field with a display value, and then simply use the display value field.

If you insist on using variables, you could construct the search expression into another variable during the load (but you would probably still need a lookup of opportunity to display value).

Re: Field Level Trigger Variables table driven

vikasmahajan — Tue, 31 May 2016 08:20:03 GMT

yes exactly

Re: Field Level Trigger Variables table driven

vikasmahajan — Tue, 31 May 2016 08:21:21 GMT

thanks Jon , do you have some demo or sample for at least 2 or 3 .

Vikas

Re: Field Level Trigger Variables table driven

vikasmahajan — Tue, 31 May 2016 08:26:28 GMT

We are using this variables to show totals , and other statistics using dynamic.

Vikas

Re: Field Level Trigger Variables table driven

Kushal_Chawda — Tue, 31 May 2016 09:00:19 GMT

Can you create the Inline table like below and link to Initative field

Data:

LOAD * inline "

Initative, FieldName

Backup Decom - Non PROD ,[NonPrdBkp.Hostname]

Backup Decom - PROD , [BackupProd.Hostname]

....

SAN ReTier - DEV, [SANReTier.HostKey] ";

Select Initative you want ,

Now You can create the single variable vField , and call FieldName in variable

vField

= FieldName

then you can call this variable to show totals

Re: Field Level Trigger Variables table driven

vikasmahajan — Tue, 31 May 2016 11:11:40 GMT

Ok Thanks Kush I will try n get back.

Vikas

Re: Field Level Trigger Variables table driven

vikasmahajan — Tue, 31 May 2016 11:14:34 GMT

can you create one small qvw example to get rid.

Vikas

Re: Field Level Trigger Variables table driven

Kushal_Chawda — Tue, 31 May 2016 11:22:00 GMT

I don't have QlikView in my system right now. I will try to create it once I reached home.

Re: Field Level Trigger Variables table driven

vikasmahajan — Tue, 31 May 2016 12:00:50 GMT

Sure , Thanks

Vikas