topic Re: Excluding a value from a dimension in QlikView

Excluding a value from a dimension

Wed, 08 Jun 2016 08:35:46 GMT

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

Re: Excluding a value from a dimension

Anonymous — Wed, 08 Jun 2016 08:45:19 GMT

you can define as calculated dimension

if (Age <> 'Other', Age)

of you can use set Analysis in expression

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

Re: Excluding a value from a dimension

Kushal_Chawda — Wed, 08 Jun 2016 08:47:11 GMT

use below expression

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

Re: Excluding a value from a dimension

Wed, 08 Jun 2016 09:05:46 GMT

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?

Re: Excluding a value from a dimension

avinashelite — Wed, 08 Jun 2016 09:07:18 GMT

try like this

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

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

Re: Excluding a value from a dimension

Anonymous — Wed, 08 Jun 2016 09:13:51 GMT

attach a small sample qvw

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

Re: Excluding a value from a dimension

Wed, 08 Jun 2016 09:26:28 GMT

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

Re: Excluding a value from a dimension

sasikanth — Wed, 08 Jun 2016 09:31:13 GMT

try some thing like

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

Calculate the same at script level

Load * ,

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

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

Re: Excluding a value from a dimension

sangeethag — Wed, 08 Jun 2016 10:09:47 GMT

Hi,

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

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

Re: Excluding a value from a dimension

Anonymous — Wed, 08 Jun 2016 10:38:13 GMT

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

Re: Excluding a value from a dimension

susovan — Wed, 08 Jun 2016 10:53:41 GMT

Try this attachement,

Re: Excluding a value from a dimension

sasiparupudi1 — Wed, 08 Jun 2016 10:55:21 GMT

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