Show Missing Sales

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Show Missing Sales

florentina_doga — Wed, 04 May 2016 07:07:45 GMT

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

topic Re: Show Missing Sales in QlikView

Show Missing Sales

Re: Show Missing Sales