Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

i have this table,in which for product A and B we have data_details of 1st week , for second week my calculation will be data_details(1st week)-sales(1st week) for third week my calculation will be data_details(2nd week)-sales(2ndweek) and same for all

Header 1Header 2Header 3Header 4Header 5
productweeksdata_detailsmonthsales
A1345jan234
B1345jan343
A2jan334
B2jan243
A3feb654
B3feb234
A4feb324
B4feb45
A5mar45
B5mar56
A6mar67
B6mar456

i have this table,in which for product A and B we have data_details of 1st week ,

for second week my calculation will be data_details(1st week)-sales(1st week)

for third week my calculation will be data_details(2nd week)-sales(2ndweek)


and same for all next

if i select product A and week 4  then it should give data_details calculated from 3rd weeks data ?how can i do it ?help me out

0 Replies