Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Any suggestions please in set analysis
See duplicate post: https://community.qlik.com/t5/QlikView-Scripting/Quotes-in-Set-Analysis-change-in-behavior-quot-erro...
Regards,
Brett