Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
New-Qlik
Creator II
Creator II

Set Analysis syntax

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)

2. 

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)

3 Replies
Vegar
MVP
MVP

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

New-Qlik
Creator II
Creator II
Author

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
MVP
MVP

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