This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a bar chart with GP_Bucket as dimension and Count, Sales as expressions as shown below;
I want to sort the dimension in the following order > '<10%','10-14%','14-20%','20-25%', '25-30%', '30-35%', '35-40%', '>40%'
I tried to use the sort -> expression as
match(GP_Bucket,'<10%','10-14%','14-20%','20-25%', '25-30%', '30-35%', '35-40%', '>40%')
which didn't sort as per the order as shown in the image above.
I even tried using in the back end script as (Sort -> expression -> GM_Bucket_Sort)
if(GP_Bucket = '<10%', 1,
if(GP_Bucket = '14-20%',3,
if(GP_Bucket = '20-25%',4,
if(GP_Bucket = '25-30%',5,
if(GP_Bucket = '30-35%',6,
if(GP_Bucket = '35-40%',7,
if(GP_Bucket = '>40%',8)))))))) as GM_Bucket_Sort,
Is there any other way to sort the dimension, or am I doing wrong here? any help is appreciated.
You GM_Bucket_Sort should work. I would set the expression:
Make sure that the sort expression is the first ranked one and there are no other check boxes clicked on.
View solution in original post
Are you able to supply us with a qvw?
How is the field GP_Bucket created in the script? Or is it a calculated dimension?
create an inline load like below just before the Load script where you have the field GP_Bucket.
Load * inline [
Reload the app and then in your Bar Chart Properties > Sort > Select Dimension GP_Bucket and then select sort by
Load Order > Original
Post your workbook if you still didn't get the desired result.
This is how I created in the scipt ;
if(GM_As_Sold <= 10, '<10%',
if(GM_As_Sold > 10 and GM_As_Sold <= 14 ,'10-14%',
if(GM_As_Sold > 14 and GM_As_Sold <= 20, '14-20%',
if(GM_As_Sold > 20 and GM_As_Sold <= 25, '20-25%',
if(GM_As_Sold > 25 and GM_As_Sold <= 30, '25-30%',
if(GM_As_Sold > 30 and GM_As_Sold <= 35, '30-35%',
if(GM_As_Sold > 35 and GM_As_Sold <= 40, '35-40%',
if(GM_As_Sold > 40, '>40%')))))))) as GM_Bucket,
thank you Niclas, it worked like a charm