topic Re: Categorising Data in QlikView

Categorising Data

Mon, 03 Nov 2014 11:48:45 GMT

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

Re: Categorising Data

MK_QSL — Mon, 03 Nov 2014 11:50:26 GMT

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

Re: Categorising Data

danieloberbilli — Mon, 03 Nov 2014 11:54:00 GMT

you could use a calculated dimension with

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

Re: Categorising Data

danieloberbilli — Mon, 03 Nov 2014 11:57:38 GMT

Re: Categorising Data

danieloberbilli — Mon, 03 Nov 2014 12:01:48 GMT

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 ...

Re: Categorising Data

amit_saini — Mon, 03 Nov 2014 12:02:24 GMT

Rob,

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

assign variable to categorise values from data tables

Thanks,

Re: Categorising Data

Mon, 03 Nov 2014 12:11:22 GMT

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