topic Re: correction of expression in QlikView

correction of expression

Wed, 25 Nov 2020 16:16:04 GMT

I am new to qlik,

pls. help to correct the below expression

I want to sum of column amount-Sep 2016 where main column =Account receivable

sum( {$<Main={'Account Receivable'}>}amount-Sep 2016)

Re: correction of expression

rubenmarin — Fri, 20 Oct 2017 16:12:51 GMT

Hi Mohammed, is that the name of a filed or the caption a table column?

If it's a field, you only need to enclose the name between []:

sum( {$<Main={'Account Receivable'}>} [amount-Sep 2016])

If it's a column label I will need to know the expression that creates that column to replicate it with the condition to filter Main={'Account Receivable'}

Re: correction of expression

Sun, 22 Oct 2017 07:30:46 GMT

Hi, Ruben,

Is name of filed,

Its working after adding []

Thank You