Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

correction of expression

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)

2 Replies
rubenmarin1

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'}

Not applicable
Author

Hi, Ruben,

Is name of filed,

Its working after adding []

Thank You