Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist
‎2018-08-12 02:21 PM

Can the class function be used in making buckets over exressions

Hi Members,

As per the data below, instead writing an if statement to group the total (premium value) like 0-1000,1000-5000,5000-10000  etc, how class function be used in a separate table  instead?

Thanks

Neville

       

BRANCH_CODECLASS_CODEPRODUCT_CODEPOL_POLICY_NONAMEREF_NOFROM_DATEEND_DATEPOL_SUM_INSUREDTR_DATETR_TYPECPRSTCTOTALMARKETING_PERSON
EM00CHPHEM0015PH0001316MR L.L. SAMEERA DILRUKEM0018D004343728-Jan-1828-Jan-19028-Jan-18REN1688.45001688.4553459 - K.G.D. PREMARATHNA
EM00CHPHEM0017PH0001945MR S.K. ATHUKORALAEM0018D004346429-Jan-1829-Jan-1940000029-Jan-18REN1688.45001688.4557494 - G.H.M.D NUWAN SAMEERA
EM00CHPHEM0017PH0002217MRS K.O. SIRIYAWATHIEM0018C000668028-Nov-1728-Nov-18029-Jan-18REF-1688.4500-1688.4559658 - G.G. SAJITH BUDDHIKA
EM00CHPHEM0017PH0002215MR J.R.A. UVINDRA LAKMALEM0018C000667928-Nov-1728-Nov-18029-Jan-18REF-1688.4500-1688.4559865 - S.J. KIRTHI MADURANGA
EM00CHPHEM0018PH0002296MR D.M. PRIYANGANI DISSANAYAKAEM0018R016994529-Jan-1828-Nov-1840000029-Jan-18NEW1688.45001688.4515390 - H. VIJITHA KUMARA
EM00CHPHEM0018PH0002297MRS K.O. SIRIYAWATHIEM0018R016994629-Jan-1828-Nov-1840000029-Jan-18NEW1688.45001688.4515390 - H. VIJITHA KUMARA
EM00CHPHEM0017PH0002218MRS D.M. PRIYANGANI DISANAYAKAEM0018C000668128-Nov-1728-Nov-18029-Jan-18REF-1688.4500-1688.4559658 - G.G. SAJITH BUDDHIKA
EM00CHPHEM0018PH0002304Mrs W. ANURADAEM0018D004350630-Jan-1830-Jan-1940000030-Jan-18NEW1688.45001688.4557861 - A.G.T. DINUSHA JAYATHILAKA
EM00CHPHEM0017PH0001948MR H.J.M.D.N. BANDARAEM0018D004349430-Jan-1830-Jan-19030-Jan-18REN1688.45001688.4509203 - K.P. CHAMINDA SILVA
EM00CHPHEM0018PH0002305Mrs W. ANURADAEM0018D004350730-Jan-1830-Jan-1940000030-Jan-18NEW1688.45001688.4557861 - A.G.T. DINUSHA JAYATHILAKA
EM00CHPHEM0018PH0002298MR K. MANOJ BUDDIKAEM0018D004346930-Jan-1830-Jan-1940000030-Jan-18NEW1688.45001688.4559341 - M.A. SURES BANDARA
EM00CHPHEM0015PH0001520MR M.A.S. DUMIDUEM0018D004351030-Jan-1830-Jan-1940000030-Jan-18REN1688.45001688.4557861 - A.G.T. DINUSHA JAYATHILAKA
EM00CHPHEM0015PH0001519MR M.A.S. DUMIDUEM0018D004350930-Jan-1830-Jan-1940000030-Jan-18REN1688.45001688.4557861 - A.G.T. DINUSHA JAYATHILAKA
EM00CHPHEM0018PH0002300MR A.N. THARANGAEM0018D004347430-Jan-1830-Jan-1940000030-Jan-18NEW1688.45001688.4559749 - R.S. DULANJAN RUBASINGHE
EM00CHPHEM0018PH0002301MR J.R.A. UVINDRA LAKMALEM0018D004348230-Jan-1828-Nov-1840000030-Jan-18NEW1688.45001688.4559865 - S.J. KIRTHI MADURANGA
EM00CHPHEM0017PH0001953MR M.K. RANJITHEM0018D004349130-Jan-1830-Jan-19030-Jan-18REN1688.45001688.4509203 - K.P. CHAMINDA SILVA
EM00CHPHEM0018PH0002299MR K. MANOJ BUDDIKAEM0018D004347030-Jan-1830-Jan-1940000030-Jan-18NEW1688.45001688.4559341 - M.A. SURES BANDARA
EM00CHPHEM0016PH0001934MR. J.M.W RANDENIYAEM0018D004350830-Jan-1830-Jan-1940000030-Jan-18REN1688.45001688.4557861 - A.G.T. DINUSHA JAYATHILAKA
EM00CHPHEM0018PH0002302MR R.A.P. KUMARAEM0018D004348630-Jan-1830-Jan-1940000030-Jan-18NEW1688.45001688.4509203 - K.P. CHAMINDA SILVA
EM00CHPHEM0018PH0002303MR M.K. RANJITHEM0018D004349330-Jan-1830-Jan-1910000030-Jan-18NEW1688.45001688.4509203 - K.P. CHAMINDA SILVA
EM00CHPHEM0017PH0001956MR D.G.C.G. PRASANGAEM0018D004349530-Jan-1830-Jan-19030-Jan-18REN1688.45001688.4509203 - K.P. CHAMINDA SILVA
EM00CHPHEM0017PH0001955MR L.P.A. SANJEEWAEM0018D004348930-Jan-1830-Jan-19030-Jan-18REN1688.45001688.4509203 - K.P. CHAMINDA SILVA
EM00CHPHEM0017PH0001950MR T.W.K.H. KUMARAEM0018D004349230-Jan-1830-Jan-19030-Jan-18REN1688.45001688.4509203 - K.P. CHAMINDA SILVA
EM00CHPHEM0017PH0001954MR T.T.S. LAKMALEM0018D004349030-Jan-1830-Jan-19030-Jan-18REN1688.45001688.4509203 - K.P. CHAMINDA SILVA
EM00CHPHEM0017PH0001980MR R.M. PREMATHILAKAEM0018D004341430-Jan-1830-Jan-19030-Jan-18REN1688.45001688.4515390 - H. VIJITHA KUMARA
EM00CHPHEM0016PH0001595MR P.K.W. RATHNAYAKEEM0018D004318031-Jan-1831-Jan-19031-Jan-18REN1688.45001688.4507184 - D.L.W. WICKRAMATHUNGA
EM00CHPHEM0015PH0001322MR. H.G.D. MAHESH KUMARAEM0018D004343531-Jan-1831-Jan-19031-Jan-18REN1688.45001688.4553459 - K.G.D. PREMARATHNA
EM00CHPHEM0017PH0001992MRS E.M. INDRANIEM0018D004330731-Jan-1831-Jan-19031-Jan-18REN1688.45001688.4557861 - A.G.T. DINUSHA JAYATHILAKA
EM00CHPHEM0016PH0001588MR. I.G. SAMEERAEM0018D004330631-Jan-1831-Jan-19031-Jan-18REN1688.45001688.4557861 - A.G.T. DINUSHA JAYATHILAKA
EM00CHPHEM0016PH0001572MR. K.A. JEEWAN KUMARAEM0018D004330831-Jan-1831-Jan-19031-Jan-18REN1688.45001688.4557861 - A.G.T. DINUSHA JAYATHILAKA
EM00CHPHEM0017PH0001985MR G.K.T. PRABATH KARUNARATHNEEM0018D004340831-Jan-1831-Jan-19031-Jan-18REN1688.45001688.4553459 - K.G.D. PREMARATHNA
EM00CHPHEM0017PH0001986MR G.K.T. PRABATH KARUNARATHNEEM0018D004340931-Jan-1831-Jan-19031-Jan-18REN1688.45001688.4553459 - K.G.D. PREMARATHNA
EM00CHPHEM0017PH0001996MR W.A.A. PUSHPALALEM0018D004340631-Jan-1831-Jan-19031-Jan-18REN1688.45001688.4553459 - K.G.D. PREMARATHNA
EM00CHPHEM0017PH0001984MR G.K.T. PRABATH KARUNARATHNEEM0018D004340731-Jan-1831-Jan-19031-Jan-18REN1688.45001688.4553459 - K.G.D. PREMARATHNA
EM00CHPHEM0017PH0001999MR. T.W. PUSHPA KUMARAEM0018D004340431-Jan-1831-Jan-19031-Jan-18REN1688.45001688.4553459 - K.G.D. PREMARATHNA
EM00CHPHEM0017PH0001998MR. T.W. PUSHPA KUMARAEM0018D004340531-Jan-1831-Jan-19031-Jan-18REN1688.45001688.4553459 - K.G.D. PREMARATHNA
EM00CHPHEM0017PH0001990MR. W.L. THUSHANTHAEM0018D004327731-Jan-1831-Jan-19031-Jan-18REN1688.45001688.4553459 - K.G.D. PREMARATHNA
EM00CHPHEM0017PH0001988MR. K.A. NISHANTHAEM0018D004327531-Jan-1831-Jan-19031-Jan-18REN1688.45001688.4553459 - K.G.D. PREMARATHNA
498 Views
0 Likes
3 Replies
Anil_Babu_Samineni
MVP
MVP
‎2018-08-12 08:40 PM

May be this?

Replace(class(POL_SUM_INSURED, 5000),' <= x < ','-')

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
414 Views
0 Likes
nevilledhamsiri
Specialist
Specialist
‎2018-08-13 01:02 PM
Author

In response to Anil_Babu_Samineni

Seems to be not doing the classes as expected. Please see where I have gone wrong?

Thanks

policy register_2018.qvw
414 Views
0 Likes
MarcoWedel
MVP
MVP
‎2018-08-13 06:00 PM

Hi,

maybe one solution could be:

Custom Filter(unusual range)

hope this helps

regards

Marco

414 Views
0 Likes