If statement in Load script

Thu, 04 Feb 2016 14:59:51 GMT

Hi Guys,

I have a scenario here:

Our client Fiscal Year start from Apr to March. So we are loading data month wise. We have Year column and we don't have month column in the table. But we have columns like cost1, cost2 , cost3 which are month related column. So I am taking cost 1 as month 1 , cost 2 as month 2 and so on. The actual output i need is when month is 1 or 2 or 3 the year should remain as previous year. For example I am loading Jan 2014 data but it should show Jan 2013 only as it comes under Fiscal Year 2013. I want to achieve this in Load script.

For this I did as Select IF(Month in (1,2,3), YEAR-1, YEAR) as Year but its failing.

Please let me know how can i do this. Thanks in advance.

Best Regards,

Shankar.

Re: If statement in Load script

Thu, 04 Feb 2016 17:54:43 GMT

Hi Uma, try this

IF(Match(Month,1,2,3),YEAR-1,YEAR) AS YEAR

Hope it helps

Regards,

Re: If statement in Load script

yura_ratu — Thu, 04 Feb 2016 18:26:23 GMT

Read this post Fiscal Year to get ideas how to handle Fiscal year in Qlikview

topic If statement in Load script in QlikView

If statement in Load script

Re: If statement in Load script

Re: If statement in Load script