Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

problem with expression script

Hey,

can you help me with this expression?
something is wrong?

= if(#num(ENTRY_DATE)<num#(if(weekday(today())='Mo', date(today()-10), if(weekday(today())='Sa', date(today()-9), date(today()-8)),

          nullcount(MISSION_OPEN), 0 )

4 Replies
tresesco
Not applicable

Re: problem with expression script

if(#num(ENTRY_DATE)<....

num# and NOT#num

simondachstr
Not applicable

Re: problem with expression script

Furthermore one bracket ) is missing

= if(num#(ENTRY_DATE)<num#(if(weekday(today())='Mo', date(today()-10), if(weekday(today())='Sa', date(today()-9), date(today()-8))),

          nullcount(MISSION_OPEN), 0 )

Not applicable

Re: problem with expression script

It looks like its your weekdays that are causing the issue. I think it should be 'Mon' and 'Sat'.

If you try that, it may help.

Not applicable

Re: problem with expression script

yes is num# and i miss a ) but not in the script.

The weekday is correct