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

Announcements
We are aware of an issue with the Product Downloads page and looking into it.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Syntax - Time Period

I have a report containing three columns: Posting Date, Amount, and Category. Each category consists of B, O, and C. I added a column to sum up categories B + O. and another column to sum up category C. I would like to add a filter to column (sum B+O) so that column stops adding after 06/15/2013. Basically this column will refresh between 05/01/2013 and 06/15/2013 but not beyond that date. How can I do that? I want all other columns in the report to keep refreshing beyond 06/15/2013. My expression for that specific column is:

 

sum

(if(Category = 'B' or Category = 'O', Amount)/FXMay2013)

The posting date format is DD/MM/YYYY

Labels (1)
0 Replies