Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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'}
Hi, Ruben,
Is name of filed,
Its working after adding []
Thank You