Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

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
Highlighted

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
Highlighted
MVP & Luminary
MVP & Luminary

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

Oleg Troyansky

Masters Summit for Qlik is going virtual! Nov 18th - I'll teach Advanced Set Analysis and AGGR

Highlighted
Specialist
Specialist

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

Highlighted

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

Highlighted
Master III
Master III

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.