topic Re: Create categories with the script in QlikView

Create categories with the script

Thu, 28 Apr 2016 08:26:24 GMT

Hello,

Using the script, I would create three class of merchants :

- those who make between 0 and 50 operations in the month,

- those who make vetween 50 and 100 operations in the month,

- those carrying out more than 100 operations in the month.

For information, I use several tables whose :

operations (fact table) which contains operationId, operationAmount, etc.

merchants (measure table) which contains merchantsId, etc.

operationsCalendar (measure table) which contains creationDate, creationDateDay creationDateMonth, creationDateYear, etc.

...

Could someone help me? Or send me examples of creation of categories so that can inspire me?

Should I use the fonction resident or a SQL query?

Thank you in advance,

Have a good day,

Prees

Re: Create categories with the script

sunny_talwar — Thu, 28 Apr 2016 15:31:06 GMT

Would you be able to share some sample (raw) data with your expected output to help you better?

Re: Create categories with the script

Fri, 29 Apr 2016 07:42:58 GMT

I would like to create this 3 categories :

- occasional merchants (those who make between 0 and 50 operations in the month),

- medium merchants (those who make between 50 and 100 operations in the month),

- heavy merchants (those carrying out more than 100 operations in the month).

I would have something (object) that would look like this :

	Occasional merchants	Medium merchants	Heavy merchants
october 2015	5	10	3
november 2015	12	15	5
december 2015	10	25	14
january 2016	11	20	18
february 2016	20	30	12
march 2016	18	37	19

So, from one month to the next, one merchant can change merchant category.

Re: Create categories with the script

sunny_talwar — Fri, 29 Apr 2016 19:12:55 GMT

This is an output you are looking for, I am looking for raw data that would help us get to the output you are looking for. I think without knowing how the raw data looks, it would be just guess work.

Preparing examples for Upload - Reduction and Data Scrambling