topic Re: Issue with passing variable in a pick expression in QlikView

Issue with passing variable in a pick expression

Wed, 25 Nov 2020 16:16:04 GMT

My expression works fine.

=$(vTriangle(

$(=

sum({<$(vCalendarIgnoreSA), Link_Date={'$(=vToDate)'}>} NewEsignApprovals)

-sum({<$(vCalendarIgnoreSA), Link_Date={'$(=vToDatePrior)'}>} NewEsignApprovals)

)))

But when I try to put a pick, it throws an error, any idea why?

=pick(vTimeDim,$(vTriangle(

$(=

sum({<$(vCalendarIgnoreSA), Link_Date={'$(=vToDate)'}>} NewEsignApprovals)

-sum({<$(vCalendarIgnoreSA), Link_Date={'$(=vToDatePrior)'}>} NewEsignApprovals)

))),' ')

All suggestions and help greatly appreciated.

-Roy

Digvijay_Singh — Tue, 19 Jul 2016 18:51:06 GMT

Not sure but the only difference I could see is '=' sign before the expression when using pick.

Clever_Anjos — Tue, 19 Jul 2016 19:28:07 GMT

does vTimeDim returns which type of numbers?

susovan — Wed, 20 Jul 2016 05:17:01 GMT

Hi Aditya,

You can also try this,

=pick(Match(vTimeDim,$(vTriangle($(=sum({<$(vCalendarIgnoreSA), Link_Date={'$(=vToDate)'}>} NewEsignApprovals)

-sum({<$(vCalendarIgnoreSA), Link_Date={'$(=vToDatePrior)'}>} NewEsignApprovals)

)))),' ')