Create percent buckets

newqlik2017 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

How do we create buckets with different percent in Qlikview? I used Agg() function but don't get the quite correct result.

Attached is the image of raw data-table1 and the final output- table2. Here's what am need help with.

1) Create 5 different percent buckets

2) Assign the appropriate values to each bucket

3) Color code each percent bucket columns (I get same colors for all columns but need different color for each column)

Attached is the qvw for reference.

Country	Account No	Premium	Amount	Ratio
USA	101	100	200	200%
USA	102	200	25	13%
USA	103	300	35	12%
USA	104	400	150	38%
USA	105	500	175	35%
USA	106	600	400	67%
USA	107	700	35	5%
USA	108	800	40	5%
USA	109	100	15	15%
USA	110	200	160	80%
CANADA	201	150	50	33%
CANADA	202	250	200	80%
CANADA	203	350	150	43%
CANADA	204	450	50	11%
CANADA	205	550	100	18%
CANADA	206	650	675	104%

Country		>0-25%	>25-50%	>50-75%	>75-100%	>100%+
USA	Premium	2100	900	600	200	100
	Amount	150	325	400	160	200
	No. of Accounts	5	2	1	1	1
CANADA	Premium	1000	500	0	250	650
	Amount	150	200	0	200	675
	No. of Accounts	2	2	0	1	1

Re: Create percent buckets

newqlik2017 — Thu, 12 Jul 2018 19:14:56 GMT

I had to tweak the dimension field to get the correct buckets. Also, the color coding worked after applying the same logic for each expression and the calculated dimension.

Thanks for checking this post.

topic Create percent buckets in QlikView

Create percent buckets

Re: Create percent buckets