Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Peter_Brunner
Creator
Creator

Help Set Analysis, Grouping of Top Customer Sales and Area Group using Top 10 Slider

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

15 Replies
Peter_Brunner
Creator
Creator
Author

Yes Gysbert that is correct and thank you
I notice you  used the
=aggr(dual(Customer_Name,sum(Sales)),Customer_Name)

in dimension what does the Dual actually do ?
Peter
perumal_41
Partner - Specialist II
Partner - Specialist II

Hi

I have uploaded one application please check is correct or not.

 

Peter_Brunner
Creator
Creator
Author

Thanks for your efforts, Gysbert has solved it

thank you agian

and sorry if I did not explain it properly, thats my fault!

regards Peter

Gysbert_Wassenaar

The dual function creates a 'value' with both a textual and numeric representation. In this case the numeric value is the sum of the Sales for the customer and the textual value is the name of the customer. That way you can sort it numerically and still display it as customer name.


talk is cheap, supply exceeds demand
Not applicable

Excellent example. Thank you very much! 🙂

Not applicable

Big thank you Gysbert!  Your response to this question pulled me out of a pit of despair and made my report work the way the client wants.