7 Replies Latest reply: Nov 20, 2015 11:52 AM by Stefan Wühl RSS

    Qliksense use valuelist, aggr() and count()

    André Ficken

      Hi there, here is my second challenge of the day.... being a relative freshman in Sense.

      I need a barchart of customers with a total turnover over 50k, 20-50k and 0-20k. The bar should show total turnover in that categorie and I would also like to show the number of customers that build up the total revenue.

       

      The categories are made with a valuelist, but how can I get the aggregate for each categorie and the count of customers in it??

       

      Thanks for the help, again....