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: 
Not applicable

Displaying weekly data points in a line or bar chart

I have a table with weekly summary information.  When I use a line or bar chart, it displays empty/null values for dates.

Any recommendations on just showing weekly # graphically.

BTW, the dates are in YYYY/MM/DD format.

3 Replies
robert_mika
Master III
Master III

Could you post sample of your data?

Not applicable
Author

The following is sample of "Weekly" data.  Each entry has ##s for a week ending date.

Sample data:

WeekDateEnding Location Wk_TotalVMCount
11/9/14 NYC 999
11/16/14 NYC 2000
11/23/14 NYC 5000
11/30/14 NYC 1000
12/7/14 NYC 4000
12/14/14 NYC 4500
12/21/14 NYC 6000
12/28/14 NYC 999
1/4/15 NYC 2000
1/11/15 NYC 5000
1/18/15 NYC 1000
11/9/14 NYC 4000
11/16/14 NYC 4500
11/23/14 NYC 6000
11/30/14 NYC 999
12/7/14 NYC 2000
12/14/14 NYC 5000
12/21/14 NYC 1000
12/28/14 NYC 4000
1/4/15 NYC 4500
1/11/15 NYC 6000
robert_mika
Master III
Master III

tRY THIS:

load

  if(MID(WeekDateEnding,2,1)='/' OR MID(WeekDateEnding,3,1)='/',Date#(WeekDateEnding,'MM/DD/YY'),DATE(WeekDateEnding,'MM/DD/YY')) as WeekDateEnding,

      Location,

    Wk_TotalVMCount

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet1);