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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.