topic Re: Calculated the data based on Calculated Column in Qlik in QlikView

Calculated the data based on Calculated Column in Qlik

gsiva1220 — Mon, 23 Oct 2017 09:08:50 GMT

Hi, I am trying to calculate a column based on another calculate column , below is the sample. Can I achieve this in Qlik Pivot table?

Preview attachment Inv1.png

Inv1.png

36 KB

Preview attachment Disp1.png

Disp1.png

161 KB

Re: Calculated the data based on Calculated Column in Qlik

devarasu07 — Mon, 23 Oct 2017 16:03:20 GMT

Hi,

unable to view your attachment. try to share it again. send us text/excel format of your current output & expected output. tks

Re: Calculated the data based on Calculated Column in Qlik

gsiva1220 — Tue, 24 Oct 2017 07:32:44 GMT

Hi devarasu07 Please have a look at the below images AX column is calculated based BD and BE and BE column is calculated based on AX, I want to achieve like this in Qliksense.

AX Column Formula: =$AW5-SUMIF($L:$L,$L5,$BD:BD)-SUMIFS(BE$4:BE4,$L$4:$L4,$L5)

BE Column Formula: =MIN(Q8,AO8,AX8)

Please find the attachments for sample files and excel data.