Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
Could you post sample of your data?
The following is sample of "Weekly" data. Each entry has ##s for a week ending date.
if(MID(WeekDateEnding,2,1)='/' OR MID(WeekDateEnding,3,1)='/',Date#(WeekDateEnding,'MM/DD/YY'),DATE(WeekDateEnding,'MM/DD/YY')) as WeekDateEnding,
(ooxml, embedded labels, table is Sheet1);