Help with a Graph Exhibiting Strange Behavior

[#1]

Hello all,

I am having issues with a graph in one of my apps. It is a graph that has two dimensions and one expression, and I am displaying it as a line chart that is stacked and shaded (filled) underneath each line. Sometimes, for reasons that aren't quite clear to me, it does something really wonky with the way it displays lines and shading. When I go into the graph and play with the sort order of the dimension, I can get it to graph correctly. I have attached two pictures, one of the graph displaying the odd behavior and one where I have changed the sort order  with it displaying correctly. Has anyone seen something like this before and could perhaps give me advice? If more information is needed, let me know.

[MarcoWedel]

missing data for some time values.

please post sample application to test solutions with.

thanks

regards

Marco

[#3]

Hey Marco,

I have attached a test file to show you what I am kind of doing. So, sometimes I do not get a hit for a specific time range. However, I always want this time range to be present in the graph to show a time line that makes sense and lets people know quickly and intuitively when people are working and when they are not. To show TimeFrame all the time regardless of there being a hit on it for the second dimension, I check "Show all Values" on the Dimensions tab for Time Frame and also I deselect the "Suppress Zero values" option on the Presentation tab.

This does what I want, but also has the unwanted effect of giving me a null value in both my TimeFrame dimension. This makes my graph look silly because there shouldn't be a null there. So, I select the box beside "Suppress When value is Null" box for TimeFrame to get rid of the null. Selecting this box makes the graph go all weird. Deselecting it brings it back to looking normal, but it also goes back to having the null value in my timeline. Do you have any suggestions? Let me know if you need clarification.

[MarcoWedel · Accepted solution]

Hi,

maybe creating express 0 values for non existing TimeFrame, SecondDimension combinations could help:

table1:
LOAD AutoNumberHash128(TimeFrame, SecondDimension) as Key, *
INLINE [
    TimeFrame, SecondDimension, express
    Time0000To0015, q, 1
    Time0015To0030, q, 2
    Time0030To0045, q, 3
    Time0045To0100, q, 1
    Time0100To0115, q, 1
    Time0115To0130, q, 1
    Time0130To0145, q, 1
    Time0145To0200, q, 1
    Time0200To0215, s, 2
    Time0215To0230, s, 5
    Time0230To0245, s, 2
    Time0245To0300, x, 2
    Time0300To0315, x, 2
    Time0315To0330, x, 2
    Time0330To0345, x, 2
    Time0345To0400, s, 2
    Time0400To0415, e, 1
    Time0415To0430, e, 1
    Time0430To0445, e, 1
    Time0445To0500, e, 1
    Time0500To0515, e, 1
    Time0515To0530, e, 1
    Time0530To0545, e, 1
    Time0545To0600, e, 1
    Time0600To0615, e, 4
    Time0615To0630, e, 4
    Time0630To0645, e, 4
    Time0645To0700, q, 4
    Time0700To0715, q, 4
    Time0715To0730, q, 4
    Time0730To0745, q, 4
    Time0745To0800, q, 1
    Time0800To0815, q, 1
    Time0815To0830, q, 1
    Time0830To0845, q, 1
    Time0845To0900, q, 1
    Time0900To0915, q, 2
    Time0915To0930, q, 3
    Time0930To0945, q, 2
    Time0945To1000, q, 1
    Time1000To1015, q, 1
    Time1015To1030, q, 2
    Time1030To1045, q, 2
    Time1045To1100, q, 1
    Time1100To1115, q, 2
    Time1115To1130, s, 1
    Time1130To1145, s, 2
    Time1145To1200, s, 1
    Time1200To1215, s, 2
    Time1215To1230, s, 1
    Time1230To1245, s, 2
    Time1245To1300, s, 1
    Time1300To1315, s, 2
    Time1315To1330, s, 1
    Time1330To1345, s, 2
    Time1345To1400, s, 1
    Time1400To1415, s, 3
    Time1415To1430, x, 2
    Time1430To1445, x, 1
    Time1445To1500, x, 2
    Time1500To1515, x, 3
    Time1515To1530, x, 1
    Time1530To1545, x, 1
    Time1545To1600, x, 1
    Time1600To1615, x, 2
    Time1615To1630, x, 2
    Time1630To1645, x, 2
    Time1645To1700, x, 2
    Time1700To1715, x, 2
    Time1715To1730, x, 2
    Time1730To1745, x, 2
    Time1745To1800, x, 3
    Time1800To1815, x, 3
    Time1815To1830, e, 3
    Time1830To1845, e, 3
    Time1845To1900, e, 3
    Time1900To1915, e, 3
    Time1915To1930, e, 3
    Time1930To1945, e, 3
    Time1945To2000, e, 3
    Time2000To2015, e, 4
    Time2015To2030, e, 2
    Time2030To2045, e, 1
    Time2045To2100, e, 2
    Time2100To2115, e, 2
    Time2115To2130, e, 2
    Time2130To2145, e, 2
    Time2145To2200, e, 1
    Time2200To2215, e, 1
    Time2215To2230, e, 1
    Time2230To2245, e, 1
    Time2245To2300, e, 1
    Time2300To2315, e, 1
    Time2315To2330, e, 3
    Time2330To2345, e, 3
    Time2345To2400, e, 3
];

tabTemp:
LOAD Distinct TimeFrame
Resident table1;
Join
LOAD Distinct SecondDimension, 0 as express
Resident table1;

Concatenate (table1)
LOAD * Resident tabTemp
Where not Exists (Key, AutoNumberHash128(TimeFrame, SecondDimension));

DROP Table tabTemp;
DROP Field Key;

hope this helps

regards

Marco

[MarcoWedel]

glad you liked the example.

Please close your thread, if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

[#6]

Thanks for the info! It was very useful.

[MarcoWedel]

You're welcome.

Glad I could help

regards

Marco