Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Lifecycle stacked bar chart with dates from column headers

Hi all,

Really struggling with this one (maybe because of the way the data is laid out?)

    

ResourceApr-16May-16Jun-16Jul-16
DaveApplicationInterview #1Interview #2Job Offer
Sarah ApplicationInterview #1Job Offer
MikeApplicationInterview #1Interview #2Job Offer
Jane ApplicationInterview #1

I'm trying to achieve a stacked bar chart showing the months along the bottom, with a count of the individual 'recruitment stages' along the side - any ideas would be really welcomed

thanks,

Pokes

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi,

You can apply crosstable in your data, doing so will transform your data into this:

  

ResourceMonthData
DaveApr-16Application
DaveJul-16Job Offer
DaveJun-16Interview #2
DaveMay-16Interview #1
JaneApr-16
JaneJul-16Interview #1
JaneJun-16Application
JaneMay-16
MikeApr-16Application
MikeJul-16Job Offer
MikeJun-16Interview #2
MikeMay-16Interview #1
SarahApr-16
SarahJul-16Job Offer
SarahJun-16Interview #1
SarahMay-16Application

CrossTable(Month, Data)

LOAD Resource,

     [Apr-16],

     [May-16],

     [Jun-16],

     [Jul-16]

FROM

[..\sample2.xlsx]

(ooxml, embedded labels, table is Sheet1);

And then you can easily create your chart.

1. Create barchart

2. Put Month and Data as Dimension

3. Count(Data) as expression

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Hi,

You can apply crosstable in your data, doing so will transform your data into this:

  

ResourceMonthData
DaveApr-16Application
DaveJul-16Job Offer
DaveJun-16Interview #2
DaveMay-16Interview #1
JaneApr-16
JaneJul-16Interview #1
JaneJun-16Application
JaneMay-16
MikeApr-16Application
MikeJul-16Job Offer
MikeJun-16Interview #2
MikeMay-16Interview #1
SarahApr-16
SarahJul-16Job Offer
SarahJun-16Interview #1
SarahMay-16Application

CrossTable(Month, Data)

LOAD Resource,

     [Apr-16],

     [May-16],

     [Jun-16],

     [Jul-16]

FROM

[..\sample2.xlsx]

(ooxml, embedded labels, table is Sheet1);

And then you can easily create your chart.

1. Create barchart

2. Put Month and Data as Dimension

3. Count(Data) as expression

Anonymous
Not applicable
Author

thanks Yddona, I'll try this at work later today...