HowTo: Create a dimension in pivot with categories.

Fri, 12 Oct 2012 08:33:02 GMT

Hello, I want to know how to create a dimension with categories ot a value sell.

for example: I have 94 records that have to look like this in a pivot:

Categories | Zones: | 1 | 2 | 3 | 4 |

____________________________________________________

from 1 to 10 | 30 | 5 | 0 | 2 |

from 10 to 20 | 2 | 2 | 4 | 9 |

from 20 to 50 | 6 | 3 | 8 | 4 |

over 50 | 9 | 2 | 6 | 2 |

_____________________________________________________

the category is a cell that have the amount of workers per company.

All records have different number of emploees. I need a way to create the dimention so that it will remove the need to add a new field in the loading script, that will create the categories, as my original database has over 400 000 records with > 2 600 fields, and from them like > 150 to become different types of categories.

So the total amount of categories is > 400.

Hope this information is clear and that it is possble to create it without the need of adding all the additional fields.

Re: HowTo: Create a dimension in pivot with categories.

Gysbert_Wassenaar — Fri, 12 Oct 2012 09:06:03 GMT

You can do it with intervalmatch. See http://community.qlik.com/thread/50880 for an example.

Re: HowTo: Create a dimension in pivot with categories.

Fri, 12 Oct 2012 09:18:34 GMT

thanks for the idea, but I am looking to do this not in the load script, as it will take ages to write all different groups, as one time I need 1-10;10-20;20-50;>50 next time I want 1-3;3-5;5-9;.... and some other categorizaions. so it will be easier to have them in the dimention of the pivot table, and not in the load script.

Hope there is a way to achive this.

topic HowTo: Create a dimension in pivot with categories. in QlikView

HowTo: Create a dimension in pivot with categories.

Re: HowTo: Create a dimension in pivot with categories.

Re: HowTo: Create a dimension in pivot with categories.