Discussion Board for collaboration related to Creating Analytics for QlikView.
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?
Go to Solution.
or even better to do it in the script and create a new Field named (e.g.) Category:
if(Field1>50000,'Category C'))) as Category
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
you could use a calculated dimension with
if(Field1<10000,'Category A', if(Field1<=50000,'Category B', if(Field1>50000,'Category C')))
Agreed with Daniel suggestion , also have a look on link below:
assign variable to categorise values from data tables
Thanks for all your help, I've got it working and looking great!