topic Range Expression in Application in QlikView

Range Expression in Application

MalcolmCICWF — Tue, 10 Jul 2012 16:05:24 GMT

I have some data displayed in an application and one of the fields is Days Delinquent, These days range from 0-100. Does anyone have experience with an expression so that I could select from this field 0-31, 32-61, and 62-100 instead of all the days shown separately?

Re: Range Expression in Application

MayilVahanan — Tue, 10 Jul 2012 16:11:05 GMT

Hi,

Try this,

In script, Use like this,

Load * , if([Days Delinquent] >=0 and [Days Delinquent] < 32 , '0-31', if([Days Delinquent] >=32 and [Days Delinquent] < 62, '32-61', '62-100')) as DateRange from tablename;

Hope it helps

Re: Range Expression in Application

nagaiank — Tue, 10 Jul 2012 16:13:07 GMT

Add a listbox with the expression

If([Days Delinquent] <= 31,'0-31',if([Days Delinquent] <= 61,'32-61','62-100'))

Hope this helps