topic Straight Table record in QlikView

Straight Table record

cbaqir — Fri, 15 May 2015 18:08:40 GMT

I'm sure that there is a simple solution to this but I have racked my brain to no avail so I am turning to you, Qlik Community...

One of my dashboards contains a simple straight table with requests and details regarding them, including Requestor. For most of the records, selecting a Requestor from a list box shows the records associated with them on each line. However, for one particular requestor, selecting her name results in one row with no request details even though there are 2 requests associated with her. I can individually select the requests from a list box and they show up just fine. This is the only exception to the dashboard.

I did notice when exporting the underlying data from the database to excel, there are some issues with line breaks but this doesn't seem to affect any other records.

I'm out of ideas. Help!

TIA,

Cassandra

Re: Straight Table record

Gysbert_Wassenaar — Fri, 15 May 2015 18:12:55 GMT

Check if that particular Requestor is greyed out when you select the two request that should be associated with her. If that Requestor is greyed out, i.e. is an excluded value, then she is definitely not associated with those requests. And check which Requestor is the possible value for those requests.

Re: Straight Table record

cbaqir — Fri, 15 May 2015 20:08:28 GMT

It is not greyed out and she is the only possibility for those records.

Re: Straight Table record

MarcoWedel — Fri, 15 May 2015 23:59:32 GMT

Hi,

maybe your straight chart's dimensions do not match the level of detail you want to present.

If there are two requests per requestor and you only have a requestor dimension, but no request dimension, then your details will not be presented in seperate lines.

One example to illustrate:

data:

table1:

LOAD * INLINE [

request, requestor, detail1, detail2

1, a, sdfg, df

2, b, fdgsd, fg

3, c, g, sgf

4, d, gfs, fdsg

5, e, dg, fd

6, e, dgf, gd

7, f, sdg, gsd

8, g, gdf, fgf

9, h, fsg, f

10, i, sdg, s

];

straight table with "requestor" as only dimension:

requestor "e" details are only shown, if one request is selected:

To display both requests for this requestor, you could:

use a table box instead of a straight table:

add request as dimension to the straight table:

hope this helps

regards

Marco

Re: Straight Table record

cbaqir — Mon, 18 May 2015 15:11:10 GMT

Thanks, Marco. That is indeed the issue. I have a link for the Request field so I believe I need to keep it as a straight table and just add Request as a Dimension.