topic Re: Field Name with a qualifier in QlikView

Field Name with a qualifier

Anonymous — Fri, 29 Jan 2016 15:26:03 GMT

I have a field name called [Anatomical Main Group]. I need to have a dimension where the [Anatomical Main Group] is restricted to one of its subgroups called [Cardiovascular System] and used as a Dimension. What expression should i use to accomplish this?

Regards.

Re: Field Name with a qualifier

sunny_talwar — Fri, 29 Jan 2016 15:28:31 GMT

Couple of ways to do this:

Use calculated dimension:

If([Anatomical Main Group] = 'Cardiovascular System', [Anatomical Main Group])

and then 'Suppress When Value Is Null' option on dimensions tab

UPDATE: you can also use Aggr function for calculated dimension:

Aggr(Only({<[Anatomical Main Group] = {'Cardiovascular System'}>} [Anatomical Main Group]), [Anatomical Main Group])

Use Set analysis in all your expressions:

{<[Anatomical Main Group] = {'Cardiovascular System'}>}

UPDATE:

I would suggest you to use set analysis, as calculated dimensions take more resources as per my knowledge (unless you have a lot of expressions)

Re: Field Name with a qualifier

swuehl — Fri, 29 Jan 2016 15:29:12 GMT

[Cardiovascular System] is a field value and you want [Anatomical Main Group] field to be restricted to this value?

=If( [Anatomical Main Group] = '[Cardiovascular System]', [Anatomical Main Group] )

Re: Field Name with a qualifier

sunny_talwar — Fri, 29 Jan 2016 15:31:52 GMT

First time ever I beat you to an answer where we have matching expression (means my expression is not going to be wrong )