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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using a formula/calculation based on day or dates selected

I have a scenario as follows.

Based on the date or date range selected if the date or date range is before 08/29/2016, I wanted to it to do one calculation (e.g A + B) and if anything after 08/29/2016 is selected, it does a different one (A + B + C).

I am doing something like this at the moment,

if(ADate < '08/29/2016', A + B, A + B +C).

The above works if I made ONE date selection only which is prior to 08/29/2016 but if I select a date range for e.g Aug 10-13, it does not work.

Any help/advice would be much appreciated.

Thank you,
Amit

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

May be try

if(Max(ADate)< '08/29/2016', A + B, A + B +C)

View solution in original post

2 Replies
settu_periasamy
Master III
Master III

May be try

if(Max(ADate)< '08/29/2016', A + B, A + B +C)

Not applicable
Author

Thank you! This solved it.