Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

Quotes in Set Analysis change in behavior - "error in expression"

Hello All,

I got deployed all my dashboard to new Qlikview server, this change has been impacted all my set analysis.
Now all my dashboard script is impacted, Charts showing no values.

Suggested Resolution: The fix for the issue is relatively simple, replace the ‘ with “ in your script IF you are impacted.
As per their request i have change the set analysis its not working for me, could some one suggest me where should i update the change.

Variable -- vMonth = =if(len(GetCurrentSelections()),max(MonthYear),MonthStart(Today()))

Set Analysis:

if(ELE_VALUE = 'MON',Num(MaxString({<Month=,MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}FCT_ACT),'$###,###.00')&'',
if(ELE_VALUE = 'PCT',Num(MaxString({<Month=,MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}FCT_ACTL)*100,'##.0%'&' ')&'',
if(ELE_VALUE= 'QTY',Num(MaxString({<Month=,MonthYear={"$(=Date($(vMonth),'MMM YY'))"}>}FCT_ACT),',###,###.'))))

Can some one suggest me where should i update the change.


Thanks in Advance
NR

2 Replies
NavinReddy
Creator II
Creator II
Author

Any suggestions please in set analysis 

Brett_Bleess
Former Employee
Former Employee

See duplicate post: https://community.qlik.com/t5/QlikView-Scripting/Quotes-in-Set-Analysis-change-in-behavior-quot-erro...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.