Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

JustinDallas
Valued Contributor II

Ignore selections in Dimension

Hello Folks,

Is there way that I can tell a Table to ignore user selections in a dimension?  I know how to do this in a Measure, but I'm not quite sure how to do this in a Dimension.

For example I have a dataset similar to the attached file (QAssist.txt).  On top of that, I have a UI that looks like so:

QAssist2.PNG

How do I make it so the user can select the {Year(JoinedTheUnion) = 1788} and still show the state of Delaware in the Statename column.

1 Solution

Accepted Solutions

Re: Ignore selections in Dimension

Create Year(JoinedTheUnion) as Year and then use Year as filer and this as expression Avg({<Year>} 1)

5 Replies

Re: Ignore selections in Dimension

Add a measure to this table

Avg({<JoinedTheUnion>} 1)

and this should prohibit Statename to go away

JustinDallas
Valued Contributor II

Re: Ignore selections in Dimension

Unfortunately, it still takes it away when I select the year.

QAssist3.PNG

Re: Ignore selections in Dimension

Try this.

Avg({<JoinedTheUnion=>} 1)


It seems stalwar1‌ forgot to mension '='.


Regards,

Kaushik Solanki

Re: Ignore selections in Dimension

Create Year(JoinedTheUnion) as Year and then use Year as filer and this as expression Avg({<Year>} 1)

JustinDallas
Valued Contributor II

Re: Ignore selections in Dimension

Thanks stalwar1‌ , the issue I had was that it has to be a datamodel field, and not one that is "calculated" on the fly.

Community Browser