topic Re: how can hard code the min date in QlikView

how can hard code the min date

Anonymous — Thu, 12 Nov 2015 04:35:30 GMT

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

Re: how can hard code the min date

tresB — Thu, 12 Nov 2015 04:54:00 GMT

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

Re: how can hard code the min date

jagan — Thu, 12 Nov 2015 04:54:45 GMT

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.

Re: how can hard code the min date

engishfaque — Thu, 12 Nov 2015 05:30:40 GMT

Dear Laura,

Have a look into attached sample file.

Kind regards,

Ishfaque Ahmed