Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

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
Valued Contributor II

Re: How to make my list box display <390 ?

Enclosed my QVF

vinieme12
Esteemed Contributor II

Re: How to make my list box display <390 ?

why not use Pick(Match( instead ?

example

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

paulyeo11
Valued Contributor II

Re: How to make my list box display <390 ?

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
Valued Contributor II

Re: How to make my list box display <390 ?

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>

Community Browser