![](/skins/images/E02BBB785254D58B89DB3F0188605285/responsive_peak/images/icon_anonymous_message.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
split range of values
Hi Guru's,
I have Account Numbers starting from 100000 to 999999 and corresponding Balances .
I want to show the output as below
Column1 column2
100000 100001
100002 and till <200000
200000 200001
200002 and Till <300000
how to achieve the requirement,please find the attached data file and out put put format in second tab of the sheet.
Thanks,
Raj
Accepted Solutions
![Contributor III](/html/@7F22A031F429FE81AFED819B1E5863E0/rank_icons/Community_Gamification-Ranking-Icons_16x16-Contributor.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please find the qvw
![ogautier62 ogautier62](https://community.qlik.com/legacyfs/online/avatars/a326632_0.png)
![Specialist II](/html/@0E4DF50C0A668F4F5116BEB444E8EE31/rank_icons/Community_Gamification-Ranking-Icons_16x16-Specialist.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
you can try as dimensions :
floor(num(AccountNumber)/100000)*100000 for col1
AccountNumber for col2
if field is num floor(account ....
regards
![vvira1316 vvira1316](https://community.qlik.com/legacyfs/online/avatars/a289319_Profile3.png)
![Specialist II](/html/@0E4DF50C0A668F4F5116BEB444E8EE31/rank_icons/Community_Gamification-Ranking-Icons_16x16-Specialist.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Rajiv,
Can you please clarify few observation on output tab.
380100 | -71,648,162.85 | ############## | |
400000 | 390100 | - | - |
400100 | - | - | |
400500 | - | - |
Is 390100 belong 300000 or 4000000?
Also you only have 100000, 200000, 3000000 but not beyond that. Is that how it should be?
![ogautier62 ogautier62](https://community.qlik.com/legacyfs/online/avatars/a326632_0.png)
![Specialist II](/html/@0E4DF50C0A668F4F5116BEB444E8EE31/rank_icons/Community_Gamification-Ranking-Icons_16x16-Specialist.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
we are not financial specialist !
you are Vijay maybe it'only under 4000000
so if(accountnumb<4000000,floor(num(AccountNumber)/100000)*100000, accountNumber)
if rule is complex : it's better to create a hierarchy
![](/skins/images/E02BBB785254D58B89DB3F0188605285/responsive_peak/images/icon_anonymous_message.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Olivier,
Thanks for your time ,tried with your expression in account number description .its not working as expected.
Thanks,
Raj
![Contributor III](/html/@7F22A031F429FE81AFED819B1E5863E0/rank_icons/Community_Gamification-Ranking-Icons_16x16-Contributor.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can try this in script
LOAD
div([PARENTA/C'],100000)*100000 as Parent_Acc,
[PARENTA/C'] as Acc,
[PTD Balance],
[YTD Balance]
FROM
[From & 2.xlsx]
(ooxml, embedded labels, table is source);
![](/skins/images/E02BBB785254D58B89DB3F0188605285/responsive_peak/images/icon_anonymous_message.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
can you post your qlikview app,for me derived field showing as blank.
![Contributor III](/html/@7F22A031F429FE81AFED819B1E5863E0/rank_icons/Community_Gamification-Ranking-Icons_16x16-Contributor.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please find the qvw
![](/skins/images/E02BBB785254D58B89DB3F0188605285/responsive_peak/images/icon_anonymous_message.png)