topic Re: Create dimention in as table - qlikview ( using aggr function in object ) in QlikView

Create dimention in as table - qlikview ( using aggr function in object )

gidon500 — Thu, 28 Oct 2021 14:21:20 GMT

Hi guys

I am tryng to create an object according to customer Margins

my data ( attached) include customer , sales and profit

according to the rate of %profit = profit/sales

create a table : levels , number of customers .

as well we need to select the customers according to the level .

in the attached excel file , you will find data and the required output object .

thanks

gidon

Re: Create dimention in as table - qlikview ( using aggr function in object )

chrismarlow — Thu, 28 Oct 2021 18:36:34 GMT

Hi,

Not sure the numbers on your spreadsheet work or how you want to handle the ranges (<, <=, >, >=) but you could try a valuelist dimension & then use that in the expression, similar to this;

Cheers,

Chris.

Re: Create dimention in as table - qlikview ( using aggr function in object )

gidon500 — Fri, 29 Oct 2021 05:33:53 GMT

Hi Chris

thanks for your mail .

can you please load the qvw documents

do you think we can implement it by aggr function

thanks

gidon

Re: Create dimention in as table - qlikview ( using aggr function in object )

gidon500 — Fri, 29 Oct 2021 05:37:07 GMT

Hi Chris

thanks for your mail .

can you please load the qvw documents

do you think we can implement it by aggr function

thanks

gidon

Re: Create dimention in as table - qlikview ( using aggr function in object )

chrismarlow — Sat, 30 Oct 2021 13:02:31 GMT

Hi,

Yes you can implement through aggr in a calculated dimension;

=aggr(if(sum(profit/sales)>0.01 and sum(profit/sales)<0.08, 'level1', if(sum(profit/sales)>0.09 and sum(profit/sales)<0.15, 'level2', if(sum(profit/sales)>0.15 and sum(profit/sales)<0.50, 'level3', 'level4' ) ) ),[Customer])

QVW attached ... I have personal edition, so not sure you will be able to do anything with it though.

Cheers,

Chris.

Re: Create dimention in as table - qlikview ( using aggr function in object )

gidon500 — Sat, 30 Oct 2021 19:03:30 GMT

thank you very much

it works great

gidon

Re: Create dimention in as table - qlikview ( using aggr function in object )

Slotherworld — Mon, 15 Nov 2021 08:37:52 GMT

Thank you for posting something like this

Re: Create dimention in as table - qlikview ( using aggr function in object )

Slotherworld — Tue, 16 Nov 2021 06:08:56 GMT

@chrismarlow wrote:

Hi,

Yes you can implement through aggr in a calculated dimension tellpizzahut ;
=aggr(if(sum(profit/sales)>0.01 and sum(profit/sales)<0.08, 'level1', if(sum(profit/sales)>0.09 and sum(profit/sales)<0.15, 'level2', if(sum(profit/sales)>0.15 and sum(profit/sales)<0.50, 'level3', 'level4' ) ) ),[Customer])
QVW attached ... I have personal edition, so not sure you will be able to do anything with it though.

Cheers,

Chris.

This helps me....