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: 
paulyeo11
Master
Master

How to make my list box display <390 ?

Hi All

I try to make my horz bar shorter. So i write the script below , But the issue is <390 and >420 does not appear . not sure where i did wrong ? Hope some one can advise me. ( pls take note that i have 2 list box , correct one can display but wrong one cannot display).

=IF([aging_ar_class]='1-30','<30',

IF([aging_ar_class]='31-60','<60',

IF([aging_ar_class]='61-90','<90',

IF([aging_ar_class]='91-120','<120',

IF([aging_ar_class]='121-150','<150',

IF([aging_ar_class]='121-150','<180',

IF([aging_ar_class]='181-210','<210',

IF([aging_ar_class]='210-240','<240',

IF([aging_ar_class]='241-270','<270',

IF([aging_ar_class]='271-300','<300',

IF([aging_ar_class]='301-330','<330',

IF([aging_ar_class]='331-360','<360',

IF([aging_ar_class]='361-390','<390',

IF([aging_ar_class]='391-420','<420'

))))))))))))))

4 Replies
paulyeo11
Master
Master
Author

Enclosed my QVF

vinieme12
Champion III
Champion III

why not use Pick(Match( instead ?

example

Pick( Match([aging_ar_class],'1-30', '31-60','61-90','91-120') , '<30','<60','<90','<120')

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
paulyeo11
Master
Master
Author

Hi Vineeth

I use your approach , it is very much simple , but it still does not able to recode arging from 361-390. why ?

Paul

paulyeo11
Master
Master
Author

Hi All

I have try to record the raw data to new field by using the Load script and it work fine now.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>