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

sachinryeola — Sat, 16 Nov 2024 18:47:39 GMT

Hi,

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

Pivot table

Expected output

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

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