KPI Seasonal measure by selected period

[devarasu07]

Hi All,

PFA, I've KPI dashboard requirement like below screen image. based on user selected Week & year need to find the current season  and last 3 season Qty. Sold measure. is there anyway to fulfill such a requirement. kindly advise.

if we changed to different period then it's Seasonal launch value should change automatically.

Attached with sample mock report, and note below,

1) our company we use customized seasonal launch master file.(source attached in the doc.)

2) report layout like above format (pivot table with column - into row transformed type)

Thanks,

Deva

[sunny_talwar]

What range of date and month do they fall into? Summer JIT 2016, Summer 2016....?

[devarasu07]

Hi Sunny,

Thanks for your kindly reply,

Please refer to the attached seasonal calendar file,

our company we follow below

Our Company
Month	Launch
1	Spring
2	Spring
3	Spring
4	Summer
5	Summer
6	Summer JIT
7	Fall
8	Fall
9	Fall
10	Winter
11	Winter
12	Winter JIT

Tks,Deva

[devarasu07]

Hi Sunny,

Launch falls on every 13 week once. if the launch falls on in between two weeks then we add month min(Date)+3 day and respective launch season.

below approach will it work? (just wondering how to convert master file below calendar script)

https://community.qlik.com/message/860026?&_ga=1.46377767.1043329824.1487776510#860026 

@maxgro

Many Thanks

Regards,

Deva

[devarasu07]

Hi stalwar1‌,

able to create monthly seasonal master calendar using below expression. based on this calendar how to get last four launch Sold Qty ?

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 SeasonLaunch;

If We select any Year & month then need to show current and last three launch Sold Qty.

FYI,

[sunny_talwar]

Can you rerun you app after adding this

LOAD*,

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 SeasonLaunch,

  Year*100+Month as MonthYear;

[devarasu07]

Hi stalwar1‌,

Sorry for the confusions, script no issue. problem is how to showing last four seasonal Sold Qty measure value based on dynamic user selected year and month.

Let Say user selected Year is 2015 & month is Dec then KPI report it should show like

Similarly if the user change year 2015 and Month is Aug it should give like

then

Thanks,

Deva

[sunny_talwar]

I know there is no issue with your script, I just need a field to use for set analysis and none of your current fields fit my requirement well enough.

[devarasu07]

Hi stalwar1‌

Will this kind of KPI requirement able to achieve using set analysis  expression? kindly share your suggestion. Thanks

Thanks Deva

[sunny_talwar]

How else you imagine doing this?