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: 
cbaqir
Specialist II
Specialist II

Expression on Table Field

I was using a table box to display detailed information for "Issues" to show additional fields of info. No calculations are needed.

However, I now have a requirement to only show data for Issues in which ISSUE_STATUS='Open'. Obviously a table box will no longer work, but I couldn't get the result I wanted with a Straight or Pivot table. Suggestions?

My only thought was to select Open from a List Box and code it as a locked bookmark but that doesn't seem right.

Thanks,

Cassandra

1 Solution

Accepted Solutions
MarcoWedel

Hi,

you have to use the set expression within an aggregation function.

Solution could be:

QlikCommunity_Thread_181043_Pic1.JPG

QlikCommunity_Thread_181043_Pic2.JPG

with either a hidden dummy expression column like Oleg suggested:

QlikCommunity_Thread_181043_Pic3.JPG

or the Only()-aggregation-function as an expression using one of your fields (given this field only has one value per the remaining dimensions/fields):

QlikCommunity_Thread_181043_Pic4.JPG

hope this helps

regards

Marco

View solution in original post

4 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

The right answer is the Straight Table with a set analysis expression that can be hidden. What was wrong when you tried it?

cbaqir
Specialist II
Specialist II
Author

I'm not sure how set analysis would apply here. I'm not doing a count or sum etc function...

=({$<ISSUE_STATUS={'Open'}>})

How would I hide it? This would be my only expression.

Thanks

MarcoWedel

Hi,

you have to use the set expression within an aggregation function.

Solution could be:

QlikCommunity_Thread_181043_Pic1.JPG

QlikCommunity_Thread_181043_Pic2.JPG

with either a hidden dummy expression column like Oleg suggested:

QlikCommunity_Thread_181043_Pic3.JPG

or the Only()-aggregation-function as an expression using one of your fields (given this field only has one value per the remaining dimensions/fields):

QlikCommunity_Thread_181043_Pic4.JPG

hope this helps

regards

Marco

Digvijay_Singh

Try this -

Only({<[Issue Status]={'Open'}>}[Issue Status]) but ensure all the other fields are used as dimensions so that condition returns only one record.