topic If relations - Put labells on orders in QlikView

If relations - Put labells on orders

Tue, 21 Sep 2010 07:04:56 GMT

Hi,

I am working on a report where I would like to add a column saying that if an order is less than 100 EUR it should be labelled "Small", if it's between 101 EUR and 499 EUR it should be labelled "Medium" and if it's 500 EUR or more it should be labelled "Large". Do you have any suggestion on how I should write the formula?

(((Sum(Sales))) < 100, 'Small' , 'Large')

worked when I just wanted to have two labells but I only get zeros in the report when trying to input a third range.

/Maria

If relations - Put labells on orders

Tue, 21 Sep 2010 07:19:54 GMT

Hi,

Try this and see. Hope it will work for you.....

if(sum(sales)<=100,'small',if(sum(sales)>100 and sum(sales)<500,'medium',if(sum(sales)>=500,'large')))

Regards,

Nilupa

If relations - Put labells on orders

Miguel_Angel_Baeyens — Tue, 21 Sep 2010 08:26:16 GMT

Even shorter (but untested) and probably faster if the amount of data is huge as it sums twice

If(Sum(Sales) <= 100, 'Small', If(Sum(Sales) < 500, 'Medium', 'Large'))

Regards