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)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I am attempting to create a table that gives a topline grouping of customers by the amount of orders they have created, I can't do this in the load script as need to be able to change time periods
It should look like this
aggr(if(count(distinct [Order ID])<=5, Text(count(distinct [Order ID])),'>5'), [Customer ID])
but it shows as a blank, if I add customer ID as a dimension I can see that the aggr is correctly grouping the customers, but just can't get it to show in the table ?
Maybe your data structure is messing it up? I just tested your formula and it works when I load very simple data:
test:Load * Inline [Customer ID, Order ID1, 101, 201, 302, 112, 211, 401, 501, 603, 1103, 1203, 1304, 1114, 1214, 1313, 1403, 1503, 1603, 170];
And I created the same table as you:
View solution in original post
Reposting - Any ideas?
Yep you must be right, I'll take another look
ok so I've used your test data and still get the same issue? Completely clean app no joins no nothing?
If I put the customer ID as a dimension I see the formulas working but really don't know what is going wrong here
If you are using a straight table then may be you can use 'Dimension Limit' tab to limit the top 5 and then show 'others; and rename the 'Others' to '<5'.
Wow, that's weird. I'm using Sense Enterprise February 2019 Patch 1. But hard to believe an older version would mess up in this way.
I can't see a dimension limit tab, I'm using Qlik Sense.
Maybe only available in Qlik view, but seemed like a great suggestion, thanks
Maybe it's an issue with the Desktop version.
I'm on Qlik Sense Desktop February 2019
Had the aggr in measure instead of dimension so your version does work
(hangs head in shame)🙄 everything's working correctly now, and was correct to begin with just under the wrong definition.