Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have an issue with a set analysis table and grouping or aggregation on 2 dimensions with a Slider for selecting Top customers Sales.
Have tried several combinations with no luck,
please see attached example I put together.
thanks
reagrds Peter
Let's try a calculated dimension then. See attached qvw.
Hi
Please Explain little bit more for my understanding
Hi
I have uploaded one application please check is correct or not.
Hi
thanks for your reply and example.
I think you are almost there
see my attached sorted exampIe, it needs harry's sales for " Building" appended to harry's other Areas "Safety and Parts"
so Areas show all togehter for harrys sales.
then you have it
Peter
If you're using QV11 you can use dimension limits. See attached qvw. Or you could use this expression Sum({<Customer_Name={"=rank(sum(total <Customer_Name> Sales))<=$(vTopCust)"}>}Sales).
Hi again Gysbert,
how have you been keeping ?
thanks for reply I have looked at your example and used the expression with variable Top Customer it works
to a point then falls over ?? if you place your expression in and use slider for 1 2 3 top customers the data shows
correct in sort order highest to lowest. but now move slider to 4 and john is above bills sales when he clearly is not ?
john should be bottom.
regards Peter
Hi
I have uploaded one application please check is correct or not.
I have had a look and no, see file attached this is correct see how it behaves select 1 top customer is shows 3 Areas for top customer
this still has a problem, all good up to this slider 3 selection all sales are in sort order for top customers
but then when we select 4 is shows John is above bills sales
john should be on bottom ....can not see what is causing this ?
Let's try a calculated dimension then. See attached qvw.