Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I'm a newbie on Qlik and I'm fighting to solve a simple issue.
I'm trying to make a chart when I show all the customers that acquire one article, how many acquire 2, 3 and so on but I have a source table which gives me the customers and the article.
I know article could be bougth by many costomers and customers may buy many articles... How I can make this selections?
I tryied using the AGGR functions but, due to big amounts of data, it hangs with no results?
Can anyone help me?
Hi Luciano!
Try to do this thing in the script.
Write Something like:
Load
Article,
Count(Customer) as Customercount
from abc.qvd group by Article;
u can also link this table with the main table by Article.