Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
New-Qlik
Creator III
Creator III

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 III
Creator III
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.