Solved: Re: Ignore selections in Dimension - Qlik Community

JustinDallas · ‎2017-09-20

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:

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.

sunny_talwar · ‎2017-09-20

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

View solution in original post

sunny_talwar · ‎2017-09-20

Add a measure to this table

Avg({<JoinedTheUnion>} 1)

and this should prohibit Statename to go away

JustinDallas · ‎2017-09-20

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

kaushiknsolanki · ‎2017-09-20

Try this.

Avg({<JoinedTheUnion=>} 1)

It seems stalwar1‌ forgot to mension '='.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

sunny_talwar · ‎2017-09-20

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

JustinDallas · ‎2017-09-20

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