Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data between specific range

Hi,

I would like to make below 2 different expressions to 1. Could you pls let me know how can I do it?

I want to show up the data which is from 2000~5000.

=if(sum(if([Notification Date]>ReloadTime()-365, [Cost]))>=2000,sum(if([Notification Date]>ReloadTime()-365, [Cost])))

=if(sum(if([Notification Date]>ReloadTime()-365, [Cost]))<5000,sum(if([Notification Date]>ReloadTime()-365, [Cost])))

Thank you very much for your help in advance.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

=if(sum(if([Notification Date]>ReloadTime()-365, [Cost]))>=2000 and

      sum(if([Notification Date]>ReloadTime()-365, [Cost]))<5000,

      sum(if([Notification Date]>ReloadTime()-365, [Cost])))


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

=if(sum(if([Notification Date]>ReloadTime()-365, [Cost]))>=2000 and

      sum(if([Notification Date]>ReloadTime()-365, [Cost]))<5000,

      sum(if([Notification Date]>ReloadTime()-365, [Cost])))


talk is cheap, supply exceeds demand
Not applicable
Author

Thank you so much! Now I know how to do it.