excel calculated formula convert into Qlikview script?
How to create below excel calculated column in Qlikview script?
Please find the attached excel source with formula, I'v tried below script using if condition method & it's working but some launch values not correct due to when launch falls in between two week then below if condition gives wrong result.
if(Month=1 or Month=2 or Month=3 , 'Spring'&'-'&Year,
if(Month=4 or Month=5, 'Summer'&'-'&Year,
if(Month=6, 'Summer JIT'&'-'&Year,
if(Month=7 or Month=8 or Month=9, 'Fall'&'-'&Year,
if(Month=10 or Month=11, 'Winter'&'-'&Year,
if(Month=12 ,'Winter JIT'&'-'&Year,
)))))) as Launch;
in the above expression wanted to apply month(min(Date)+3 condition? if i add then script not working(refer the attached document)