topic Re: Help with a Graph Exhibiting Strange Behavior in QlikView

Help with a Graph Exhibiting Strange Behavior

Wed, 26 Oct 2016 12:39:52 GMT

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.

Re: Help with a Graph Exhibiting Strange Behavior

MarcoWedel — Wed, 26 Oct 2016 23:14:09 GMT

missing data for some time values.

please post sample application to test solutions with.

thanks

regards

Marco

Re: Help with a Graph Exhibiting Strange Behavior

Thu, 27 Oct 2016 21:29:01 GMT

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.

Re: Help with a Graph Exhibiting Strange Behavior

MarcoWedel — Thu, 27 Oct 2016 23:05:32 GMT

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

Re: Help with a Graph Exhibiting Strange Behavior

MarcoWedel — Mon, 31 Oct 2016 20:57:19 GMT

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

Re: Help with a Graph Exhibiting Strange Behavior

Tue, 01 Nov 2016 12:33:25 GMT

Thanks for the info! It was very useful.

Re: Help with a Graph Exhibiting Strange Behavior

MarcoWedel — Tue, 01 Nov 2016 19:59:11 GMT

You're welcome.

Glad I could help

regards

Marco