Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Categorising Data

Hi There,

I have some data which I want to group/divide by its value. I want to split the data into three categories: value <10k, value <50k and Value >50k. How would I do this in a pie chart as an example? Do I need to set variables?

thanks

Tags (2)
1 Solution

Accepted Solutions
danieloberbilli
Valued Contributor II

Re: Categorising Data

or even better to do it in the script and create a new Field named (e.g.) Category:

LOAD

Field1,

if(Field1<10000,'Category A',

     if(Field1<=50000,'Category B',

          if(Field1>50000,'Category C')))  as Category

FROM ...

6 Replies
MVP
MVP

Re: Categorising Data

This could be done either in the script or using ValueList Function at the UI end..

Better if you can provide sample data to work... Thanks

danieloberbilli
Valued Contributor II

Re: Categorising Data

you could use a calculated dimension with

if(Field1<10000,'Category A', if(Field1<=50000,'Category B', if(Field1>50000,'Category C'))) 

danieloberbilli
Valued Contributor II

Re: Categorising Data

danieloberbilli
Valued Contributor II

Re: Categorising Data

or even better to do it in the script and create a new Field named (e.g.) Category:

LOAD

Field1,

if(Field1<10000,'Category A',

     if(Field1<=50000,'Category B',

          if(Field1>50000,'Category C')))  as Category

FROM ...

amit_saini
Honored Contributor III

Re: Categorising Data

Rob,

Agreed with Daniel suggestion , also have a look on link below:

assign variable to categorise values from data tables

Thanks,

AS

Not applicable

Re: Categorising Data

Thanks for all your help, I've got it working and looking great!