Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Please find the qvw

View solution in original post

7 Replies
Highlighted
Specialist II
Specialist II

Hi,

you can try as dimensions :

floor(num(AccountNumber)/100000)*100000  for col1

AccountNumber for col2

if field is num floor(account ....

regards

Highlighted
Specialist II
Specialist II

Hi Rajiv,

Can you please clarify few observation on output tab.

  

380100-71,648,162.85##############
400000390100--
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?

Highlighted
Specialist II
Specialist II

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

Highlighted
Creator
Creator

Hi Olivier,

Thanks for your time ,tried with your expression in account number description .its not working as expected.

Thanks,

Raj

Highlighted
Contributor III
Contributor III

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);

Highlighted
Creator
Creator

can you post your qlikview app,for me derived field showing as blank.

Highlighted
Contributor III
Contributor III

Please find the qvw

View solution in original post