Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

numbers intervals - script solution

Hello and thanks in advance

Please help me in numbers intervals

I have 2 tables:

  • intervals

   

CityIDFromSumToSumClientTypeCriteriaIDLevel
100010A201511
1001120A201512
1002130A201513
1010100A201511
101101200A201512
101201300A201513
100015A201521
1001620A201522
1002130A201523
1010100A201521
101101200A201522
101201500A201523
101020B201521
1012130B201522
1013140B201523

  • clients data

   

ClientIDCityIDClientTypeSum
22222100A10
33333100A15
44444100A30
55555101A150
66666101A100
77777101A20
88888101B600

I need to know client's level for each type and criteriaID (one client has only one type) . Also I would like to know clients without any level for each criteria

Finaly, I need to get this data in my model:

   

ClientIDCriteriaIDLevel
22222201511
33333201512
44444201513
55555201512
66666201511
77777201511
88888201510
22222201521
33333201521
44444201523
55555201522
66666201521
77777201521
88888201520
2 Replies
miguelbraga
Specialist III
Specialist III

Hi Eva,

Something like this?

Regards,

MB

Not applicable
Author

No, because I have also a sum intervals. I have 2 factors: city, client type and sum interval.

I can have 3 levels for each client type.

Now I see that  my first table is not the good example (sorry, my fault)- I've changed it