Hi everyone,
I have implemented sheet change on my qvd that triggers every second.The sheet change works fine but qlikview keeps crashing a while after I open the document.
Any ideas as to why is this happening??
Here are my trigger options:
Trigger on vShow to activate sheet:
if($(vShow)=1,'SH07',IF($(vShow)=2,'SH08',IF($(vShow)=3,'SH09',IF($(vShow)=4,'SH10',if($(vShow)=5,'SH11')))))
vShow=if($(vSeconds)<30,1
,if($(vSeconds)<60,2
,if($(vSeconds)<90,3
,if($(vSeconds)<120,4
,if($(vSeconds)<150,5)))))
vSeconds=mod(round((now()-now(2))*86400),150)
I wonder if there is any alternative to achieve what I currently do with now function, as now() causes performance issues.