Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Register by January 31 for $300 off your Qlik Connect pass: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show Missing Sales

Dears

1 - I want to display a list of all the items in the company with a flag if the selected customer has bought this item.

When I select a customer Qlikview filters the list of items to the items that the customer purchased; I need to see the items that the customer did not purchased.

2 - My customers are divided into groups based on the type of business (TOB).

I need to generate a list of top 100 selling items by TOB and then to check each customer belonging to this TOB what he purchased and what he did not purchased from the top 100 items of his TOB.

Any help?

Thank you.

1 Reply
florentina_doga
Partner - Creator III
Partner - Creator III

concatenate this

aa:

load distinct customer resident sales;

left join (aa)

load distinct product resident sales;

concatenate(sales)

load *, 0 as value resident aa;

drop table aa;

and in chart presentation suppress zero value