Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Variable working in Visualisation but not in load editor

I have created a variable as follows:

Set vCurrentFinancialYear = If(Month(Today()) >= 7,(Year(Today()) & '-' & Right(Year(Today())+1,2)),(Year(Today())-1 & '-' & Right(Year(Today()),2)));

In the visualisation it works in the following set analysis expression:

count({<[Milestone ReceivedVsDue Status] = {'Received On Due Date','Received Before Due Date'},Milestone_Type_Report_Flag ={'Y'},[Milestone_Received_Date.FY_Name]={'$(=$(vCurrentFinancialYear))' },
[SAP Branch HUB]={*}>}distinct [Milestone Id])/
count({<Milestone_Type_Report_Flag ={'Y'},Milestone_Received_Date.FY_Name={'$(=$(vCurrentFinancialYear))' },
[SAP Branch HUB]={*}>}distinct [Milestone Id])

Set vTestMeasure =
count({<[Milestone ReceivedVsDue Status] = {'Received On Due Date','Received Before Due Date'},
Milestone_Type_Report_Flag ={'Y'},[Milestone_Received_Date.FY_Name]={$(vCurrentFinancialYear}>}distinct [Milestone Id])
/
count({<[Milestone ReceivedVsDue Status] = {*},
Milestone_Type_Report_Flag ={'Y'},Milestone_Received_Date.FY_Name={$(vCurrentFinancialYear)}>}distinct [Milestone Id])
;

Set vReceivedThresholdMeasure =
count({<[Milestone ReceivedVsDue Status] = {'Received On Due Date','Received Before Due Date'},Milestone_Type_Report_Flag ={'Y'},[Milestone_Received_Date.FY_Name]={'$(=$(vCurrentFinancialYear))' },
[SAP Branch HUB]={*}>}distinct [Milestone Id])/
count({<Milestone_Type_Report_Flag ={'Y'},Milestone_Received_Date.FY_Name={'$(=$(vCurrentFinancialYear))' },
[SAP Branch HUB]={*}>}distinct [Milestone Id])
;

Why does it work in the visualisation, but not in the data load editor? Does it have to do with the fact that set doesn't evaluate the variable before I use it?  Is it the syntax?  

 

Labels (1)
1 Reply
Highlighted
Contributor II
Contributor II

Forgot to say vReceivedThresholdMeasure and vTestMeasure were what I tried in the data load editor.