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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
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)