topic Re: How to create a calculated dimension in QlikView

How to create a calculated dimension

Wed, 25 Nov 2020 16:16:04 GMT

Hello People, this is my first question so be good with me!

I have the following dilemma, I have to categorize sales in one dimension according to their sale.

Example:

the amounts of product sales in a month are over 1,000,000 must have category A, which are less than 999,999 should be category B.

this is more or less what it should show ...

if not achieve it in the script or a variable or Set analisys. I'm really lost ...

please your help.

Re: How to create a calculated dimension

Chanty4u — Thu, 07 Apr 2016 06:59:47 GMT

=if(productsales>1,000,000 [Catagory A] and productsales<999,999 [Catagory B] )

Re: How to create a calculated dimension

Kushal_Chawda — Thu, 07 Apr 2016 07:07:33 GMT

Creating calculated dimension is not good practice, it consumes more resources, instead you can create the same in the script or create the expression.

in script,

LOAD *,

if(sales>=1000000 ,'A' ,'B') as Category

FROM table

Expression:

if(sum(sales)>=1000000 ,'A' ,'B')

Re: How to create a calculated dimension

Thu, 07 Apr 2016 07:15:15 GMT

You should create an additional field in the script as

Load *,

if([product sales]>=1000000,'A', 'B') as Category

From

Your Table;

Regards,

Anjali Gupta