Table Box with Set Analysis or Table Without Aggregation

lucasdavis500 — Tue, 23 May 2017 21:14:04 GMT

Hello all,

I need help.. not sure how to do this, but maybe the right way is in script..

I have data that looks like this...

Pkey DateCreated ResponseDueDate DateResolved

123 1/1/2017 1/10/2017 1/11/2017

234 1/1/2017 1/10/2017 1/11/2017

456 1/5/2017 1/15/2017 1/14/2017

789 1/5/2017 1/15/2017 1/14/2017

101 1/7/2017 1/17/2017 1/16/2017

102 1/8/2017 1/18/2017 1/17/2017

My issue is that I need to be able to view this data in a table, and be able to see the Pkey # without aggregations. I have 3-4 filters I am using in Set Analysis to filter my data down to what I need.

My dimensions are DateCreated, ResponseDueDate and DateResolved

My expressions is:

ONLY({<SomeSetAnalysisHere>} Pkey)

I realized that I was not able to see my Pkey where my dimensions are on the same days. I am getting NULL Values. I need to be able to see each individual Pkey and not return a 'Null' Value when doing this. I cannot use a table box either as you cannot use Set analysis with this, and because of my application, if I use filters for this it will be a mess for the end-user.

This is what the output would like look with that expression:

Pkey DateCreated ResponseDueDate DateResolved

- 1/1/2017 1/10/2017 1/11/2017

- 1/5/2017 1/15/2017 1/14/2017

101 1/7/2017 1/17/2017 1/16/2017

102 1/8/2017 1/18/2017 1/17/2017

Where 101, 102 would show because they are Unique.

I need suggestions on how to view all of the Pkey even when the dimensions lie on the same day, while still being able to use set analysis. I couldn't find a lot of documentation where others have done this.

Re: Table Box with Set Analysis or Table Without Aggregation

Peter_Cammaert — Tue, 23 May 2017 21:25:23 GMT

A table box cannot show expressions, let alone aggregations that contain set analysis specs.

If PKey is the distinct value that makes every line unique, show it as a regular dimension in a straight table, and add an Only() expression with set analysis filters using any of the other fields that is however guaranteed to contain a non-null value (for example, DateCreated must exist for all rows so that would be a good candidate)

Re: Table Box with Set Analysis or Table Without Aggregation

lucasdavis500 — Thu, 25 May 2017 14:03:05 GMT

But doesn't Only() return distinct values?

topic Table Box with Set Analysis or Table Without Aggregation in QlikView

Table Box with Set Analysis or Table Without Aggregation

Re: Table Box with Set Analysis or Table Without Aggregation

Re: Table Box with Set Analysis or Table Without Aggregation