topic Re: KPI Seasonal measure by selected period in QlikView

KPI Seasonal measure by selected period

devarasu07 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Seasonal measure by selected period

sunny_talwar — Mon, 27 Feb 2017 18:25:28 GMT

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

Re: Seasonal measure by selected period

devarasu07 — Mon, 27 Feb 2017 18:35:54 GMT

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

Re: Seasonal measure by selected period

devarasu07 — Mon, 27 Feb 2017 18:41:51 GMT

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

Re: Seasonal measure by selected period

devarasu07 — Tue, 28 Feb 2017 13:03:39 GMT

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,

Re: Seasonal measure by selected period

sunny_talwar — Tue, 28 Feb 2017 13:10:10 GMT

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;

Re: Seasonal measure by selected period

devarasu07 — Tue, 28 Feb 2017 14:03:26 GMT

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

Re: Seasonal measure by selected period

sunny_talwar — Tue, 28 Feb 2017 14:04:58 GMT

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.