Visualization help

[QlikAnalyst]

Hi ,

Need help in creating attached attached visual in Qliksense.

Each book has start and end date and 3 editions .  

 Each editions has  5 different stages dates. 3 Stage is Middle with larger bubble. Color of bubble is based on edition type.

 attached is data associated with visual. 

Tried with scatter chart but no luck.. 

Thanks in advance. 

[MarcoWedel · Accepted solution]

maybe like this?

table1:
CrossTable(Stage,Date,4)
LOAD RecNo() as BookID,
     [Serial #],
     [Books],
     [Editions],
     [Start],
     [End],
     [1st],
     [2nd],
     [3rd],
     [4th],
     [5th]
FROM [lib://DataFiles/sample.xlsx] (ooxml, embedded labels, table is Sheet3);

table2:
LOAD RowNo() as ID,
     BookID,
     [Serial #],
     [Books],
     [Editions],
     Stage,
     Date(Date,'MM/DD/YYYY') as StageDate
Resident table1;

DROP Table table1;

If(Stage='Start',LightRed(),If(Stage='End',Yellow(),Pick(Match(Editions,'E1','E2','E3'),Blue(),LightGreen(),RGB(179,162,199))))

[QlikAnalyst]

Thanks for your inputs. followed same steps but I'm not getting same visualization as you mentioned. I see   single color as density.  

=If(Stage='Start',LightRed(),If(Stage='End',Yellow(),Pick(Match(Edition,'E1','E2','E3'),Blue(),LightGreen(),RGB(179,162,199))))

[MarcoWedel]

You have to check this box

[QlikAnalyst]

It's working when ID record count is less than 1000. when record count is more than 1000 it's displaying as density chart.  

Both charts have same setting only difference is volume of data.

Is it possible to replace Serial# with Values in Book column?

Thanks in Advance.

[QlikAnalyst]

 Attached is sample which is giving density line..