Qlik Community

Qlik Sense App Development

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

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

Re: Displaying weekly data points in a line or bar chart

Could you post sample of your data?

Not applicable

Re: Displaying weekly data points in a line or bar chart

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

Re: Displaying weekly data points in a line or bar chart

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);