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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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

0 Replies