Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Need help on urgent basis - Max value in pivot table and text box Qliksense

Hi,

I am facing challenge to create particular pivot table and taking those values in text box.

Pivot table

Material_1AABBCCDDEE
DB.Fiscal QuarterQty SoldQty mfgQty SoldQty mfgQty SoldQty mfgQty SoldQty mfgQty SoldQty mfg
Q1-FY18----0250780122
Q2-FY1803--048078063
Q3-FY18013--025015041
Q4-FY18060100----0187
Q1-FY1914101010170

 

Expected output

Material_1AAABBBCCCDDDEEE
DB.Fiscal QuarterQty SoldQty mfgLast mfg qtyQty SoldQty mfgLast mfg qtyQty SoldQty mfgLast mfg qtyQty SoldQty mfgLast mfg qtyQty SoldQty mfgLast mfg qty
Q1-FY18-- -- 02525078780122122
Q2-FY18033-- 048480787806363
Q3-FY1801313-- 025250151504141
Q4-FY180660100100------0187187
Q1-FY19144101001025101517070

 

Here i want to create a column with following conditions

1) if Qty sold Q1 FY 19 >0 and Qty mfg >0 then show same Qty mfg in all quarters

2) if Qty sold Q1 FY 19 =0  then show 0 Qty mfg in Q1 FY 19

3)  if Qty sold Q1 FY 19 >0 and Qty mfg <=0 then show  Qty mfg in last /max  Quarter mfg value in Q1FY19 and rest quarters to show respective mfg value 

4) then show all the summation of Q1 FY 19  mfg value in text box

Thanks,

Sachin

0 Replies