Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

What a customer orders next qliksense

Hi

I have a table that contain data of customers that order products from different departments

ID    date            department  ordernumber

1  01/01/2009  bakery            1

01/01/2009  clothing          1

3  01/01/2009  living               1

01/01/2009  comms           1

05/01/2009  bakery             2

07/01/2009  clothing          2

01/01/2009  bakery             1

I have a chart showing number of orders made for each department

How do I on a second chart show if I filter on a department  show the next department they ordered from

As at the moment if I pick bakery on the top chart

It shows bakery only for second orders on the second chart.. I want to show which department they ordered next from

Basically show trend where a customer orders next from

Please help

2 Replies
Digvijay_Singh
Honored Contributor III

Re: What a customer orders next qliksense

Can you share sample app having charts you have made so far.

joeybird
Contributor II

Re: What a customer orders next qliksense

Hi

I cant sorry... but basically chart one has the dimension - Department

the set analysis of  count({$<ordernumber={"1"}>} ID)

but I want the second chart to filter on what customers ordered next

so what type department do customers go to next for their second order... so if clothing on chart one... it will show me on chart two, ID 2 went to bakery

please help

Community Browser