topic Re: Expression on Table Field in QlikView

Expression on Table Field

cbaqir — Wed, 16 Sep 2015 19:41:20 GMT

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

Re: Expression on Table Field

Oleg_Troyansky — Wed, 16 Sep 2015 19:56:49 GMT

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

Re: Expression on Table Field

cbaqir — Wed, 16 Sep 2015 20:16:13 GMT

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

Re: Expression on Table Field

MarcoWedel — Wed, 16 Sep 2015 21:57:12 GMT

Hi,

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

Solution could be:

with either a hidden dummy expression column like Oleg suggested:

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):

hope this helps

regards

Marco

Re: Expression on Table Field

Digvijay_Singh — Wed, 16 Sep 2015 21:57:38 GMT

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.