how can hard code the min date - Qlik Community

Anonymous · ‎2015-11-11

I am testing my data and only want one financial year to load. how do I hard code the Financial year 14/15? for some reason hard coding the variables min/max year doesn't work?

Cheers,

Laura

tresesco · ‎2015-11-11

How does your data look like? Could you explain with an example?

jagan · ‎2015-11-11

Hi,

Can you attach some sample data? If you want to restrict in script then try like below

LOAD

*

FROM DataSource

WHERE FinancialYear = '14/15';

Hope this helps you.

Regards,

jagan.

engishfaque · ‎2015-11-12

Dear Laura,

Have a look into attached sample file.

Kind regards,

Ishfaque Ahmed