topic Re: Can you pass a string as a variable into an expression for evaluation in QlikView

Can you pass a string as a variable into an expression for evaluation

helen_pip — Wed, 08 Aug 2018 09:47:00 GMT

Dear Qlikview user

I was wondering if it is possible to strore a string as a variable and load in the variable as part of the expression

I.e.

Num(Count({$<Week_Number,Month,QuarterName,FiscalYear,FactDateNum=P(FactDateNum_prevYr),OP_Atd_Outcome_Type={'ACTION'},

Attendance_Type={'Follow Up'}>} Dim_OP_Counter))

Could I store the Week_Number,Month,QuarterName,FiscalYear, into a variable and then call that variable?

I.e.

v_date_exclusion = Week_Number,Month,QuarterName,FiscalYear,

Then the expression could look like this?

Num(Count({$<$(v_date_exclusion)FactDateNum=P(FactDateNum_prevYr),OP_Atd_Outcome_Type={'ACTION'},

Attendance_Type={'Follow Up'}>} Dim_OP_Counter))

Any help or guidance would be greatly apreciated

Kind Regards

Helen

Re: Can you pass a string as a variable into an expression for evaluation

sunny_talwar — Wed, 08 Aug 2018 11:17:38 GMT

This is doable, have you tried this and ran into issue?

Re: Can you pass a string as a variable into an expression for evaluation

helen_pip — Wed, 08 Aug 2018 14:12:12 GMT

Dear Sunny

We have tried this but could not get the expression to OK our syntex

Num(Count({$<$(v_date_exclusion)FactDateNum=P(FactDateNum_prevYr),OP_Atd_Outcome_Type={'ACTION'},

Attendance_Type={'Follow Up'}>} Dim_OP_Counter))

Kind Regards

Helen

Re: Can you pass a string as a variable into an expression for evaluation

sunny_talwar — Wed, 08 Aug 2018 14:16:14 GMT

Syntax editor doesn't really know what you have behind the variable... so will complain... but as long as have the correct syntax expanded, it should show the right result to you... so, I would say... ignoring the syntax editor's red wiggly line... do you see the right result?

Re: Can you pass a string as a variable into an expression for evaluation

helen_pip — Wed, 08 Aug 2018 14:24:46 GMT

Thanks Sunny

Yes, that worked! I just assumed my syntax was wrong and went no further to test my expression

Thanks for clarifying

Thanks

Helen

Re: Can you pass a string as a variable into an expression for evaluation

sunny_talwar — Wed, 08 Aug 2018 14:26:30 GMT

No problem at all.. I would keep syntax editor as a second check. Always check the result from your expression to see if it looks right. If it does, you don't have to worry about your expression.

Best,

Sunny