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

Need annalysis for variable..

Hello All,

Can any one explain me for these two variables..

1)  LET CURRENT_YEAR=(YEAR(YEARSTART(NUM(TODAY()),0,4))+1);

2)  LET CURRENT_MONTH=IF(NUM(MONTH(NUM(TODAY())))>3,NUM(MONTH(NUM(TODAY())))-3,NUM(MONTH(NUM(TODAY())))+9;

Please explain me about these two variables,where should we use this variables.

And let me know what value it will display for current month and year,and tell me what value it displays after financial year-end that is by next month.

By next month this will work or not,previous months and years value will display or not.

regards,

bar