topic Re: Set Analysis syntax in App Development

Set Analysis syntax

New-Qlik — Wed, 31 Jul 2019 21:01:09 GMT

Hi ,

Can anyone tell me difference between these two expressions

1. Sum({$<[Fiscal Year Full]={"$(=$(vCurrentFY))"}>}[Sales])/
Sum({$<[Fiscal Year Full]={"$(=$(vCurrentFY))"}>}[Qty ])

(This KPI shows correct KPI data for Fiscal years but if I pick one Order number its shows blank)

Sum({$<[Fiscal Year Full]={"=$(vCurrentFY)"}>}[Sales])/
Sum({$<[Fiscal Year Full]={"=$(vCurrentFY)"}>}[Qty ])

(This KPI shows correct KPI data for an particular Order number but by default consolidated FY data is wrong)

Vegar — Wed, 31 Jul 2019 22:42:42 GMT

How is the variable vCurrentFY defined? Does it output value change when selecting an order number?

New-Qlik — Thu, 01 Aug 2019 07:59:00 GMT

HI,

Variable is not changing when I selected that order number its still says 2019

PS: That or no is from 2018

LET vCurrentFY = PEEK('FY', 0 ,'Calender');

Vegar — Thu, 01 Aug 2019 19:16:15 GMT

To eliminate any issues with the variable try to temporary adjust the expressions replacing the $(vCurrencyFC) with a hard coded 2019.