Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
unable to view your attachment. try to share it again. send us text/excel format of your current output & expected output. tks
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.