Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nitin_01
Creator
Creator

Display projection(based on previous year data) with dimension value of Previous year

Hi experts,

I am calculating projection for F-21 based on data of F-20, have achieved the projection as per requirement and displayed same in KPI Object,but i am facing issue while displaying data at granular level in straight table. Below is the requirement.

Projection formula : 

Current FY Quantity = 75% of Previous FY Quantity

F-20 Data as per Transaction:

SupplierPartQuantity
S1P110
S2P220
S3P330

 

F-21 Data as per Transaction:

SupplierPartQuantity
S1P15
S2P25

 

Though i have few transaction in FY 21, i need to display Projected Quantity against the previous year record and display same after FY- 21 selection.

Desired Output after Selection of FY-21 in straight table.

SupplierPartQuantity
S1P17.5
S2P215
S3P322.5

 

@sunny_talwar 

Regards,

Nitin.

2 Replies
Kushal_Chawda

How year values are stored in table?

nitin_01
Creator
Creator
Author

Fiscal Year
2019
2020
2021