LOAD ID, PRODUCT, SALES, MONTH, if(Left(MONTH,3)='Aug',8,if(Left(MONTH,3)='Sep',9,if(Left(MONTH,3)='Oct',10,if(Left(MONTH,3)='Nov',11,if(Left(MONTH,3)='Dec',12))))) as MONTH_ID, YEAR FROM test.xlsx] (ooxml, embedded labels, table is Test);
I have created two variables for
and if i select August month as its showing maxmonthid is 8 and minmonthid is showing 7.
Here i don't have July month so min variable should be show Zero in variable level.It means if i don't have previous month data in it should show zero.
How to handle this scenario in qlikview can you help me on this?