Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Re: Excluding a value from a dimension

you can define as calculated dimension

if (Age <> 'Other', Age)

of you can use set Analysis in expression

sum([Age-={'Other'})yourfield

Highlighted
MVP
MVP

Re: Excluding a value from a dimension

use below expression

=sum({<Age-={'Others'}>}Value)

Highlighted
Not applicable

Re: Excluding a value from a dimension

Thanks for your suggestions.

I have a chart that shows various dimensions (depending on the button you select) for the same calculation/expression. Hence each dimension have a variable assigned to it (so that buttons work fine).

Hence the option with an expression will not work I think.

When I do a calculated dimension (if (Age <> 'Other', Age) and assign a relevant variable to the dimension, the chart still shows the "Other", the only thing that disappears is the label from the legend.

Any thoughts?

Highlighted

Re: Excluding a value from a dimension

try like this

=sum({<Age={'*'}-{'Others'}>}Value)


or

=sum({<Age-={'Others'}>}Value)

Highlighted
Partner
Partner

Re: Excluding a value from a dimension

attach a small sample qvw

what do you mean assign a relevant variable to the dimension??

Highlighted
Not applicable

Re: Excluding a value from a dimension

Hello

I'm not quite sure how to generate a small sample qvw, would the snapshots suffice?

I'm trying to get rid of "Unknown" in the chart below.

Thanks

Ewa

1.png2.PNG3.PNG

Highlighted
Specialist III
Specialist III

Re: Excluding a value from a dimension


try some thing like

sum({<attempt={1},OUTCOME={'COMPLETE'},[Ethinicity General]={'*'}-{'Unknown'}>} FPE)/sum({<[Ethinicity General]={'*'}-{'Unknown'}>}FPE)


OR

Calculate the same at script level

Load * ,

IF(Age<>'Others',Age) as New_Age ;

Load Age,.,.,.,.,,. From Tab;

Highlighted
Contributor III
Contributor III

Re: Excluding a value from a dimension

Hi,

try to exclude in expression level. add below in your expression

{<Age-={'Others'}>}

Highlighted
Partner
Partner

Re: Excluding a value from a dimension

Change your Expression to

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

EthnicityGeneral must be defined in both part of Expression

if you Need Ethnicity General included in the second sum (divide) you Need to use aggr function