Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
JustinDallas
Specialist III
Specialist III

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
sunny_talwar

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

View solution in original post

5 Replies
sunny_talwar

Add a measure to this table

Avg({<JoinedTheUnion>} 1)

and this should prohibit Statename to go away

JustinDallas
Specialist III
Specialist III
Author

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

QAssist3.PNG

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

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

JustinDallas
Specialist III
Specialist III
Author

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