Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.
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.