Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excluding a value from a dimension

Hello

I would like to exclude a value within a dimension when I do a graph/table.

For example, my dimension is "Age" and I have three categories: "24 and below", "25 and over" and "Other".

What should I do to exclude "Other" from a graph/table?

I would like to exclude it in a particular chart/table and not the whole data-set uploaded.

Thanks

Ewa

11 Replies
susovan
Partner - Specialist
Partner - Specialist

Try this attachement,

Warm Regards,
Susovan
sasiparupudi1
Master III
Master III

= sum({<[Ethnicity general]-={'Unknown'},Attempts={"1"},Outcome={"COMPLETE"}>} FPE) / sum({<[Ethnicity general]-={'Unknown'}>} FPE)