Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lucasdavis500
Creator III
Creator III

Table Box with Set Analysis or Table Without Aggregation

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.

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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)

View solution in original post

2 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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)

lucasdavis500
Creator III
Creator III
Author

But doesn't Only() return distinct values?