Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
devarasu07
Master II
Master II

KPI Seasonal measure by selected period

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.

KPI Dashboard.jpg

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

14 Replies
sunny_talwar

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

devarasu07
Master II
Master II
Author

Hi Sunny,

Thanks for your kindly reply,

Please refer to the attached seasonal calendar file,

our company we follow below

 

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

Tks,Deva

devarasu07
Master II
Master II
Author

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
Master II
Master II
Author

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,

200.jpg

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
Master II
Master II
Author

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

Example.jpg

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

then 203.jpg

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
Master II
Master II
Author

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?