topic Re: Data between specific range in QlikView

Data between specific range

Fri, 28 Jun 2013 04:41:22 GMT

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.

Gysbert_Wassenaar — Fri, 28 Jun 2013 06:26:52 GMT

=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])))

Fri, 28 Jun 2013 06:37:46 GMT

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