Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.