Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

How could the some of the field values be excluded and how the name of values could be changed?

Hey guys,

Are there any wasy to How exclude some field values, while using the rest of values of a field? Moreover, how could the name of values be changed?

Many thanks and regards!

8 Replies
sudeepkm
Valued Contributor III

Re: How could the some of the field values be excluded and how the name of values could be changed?

you can use Match or Exists functions in your script where clause to exclude certain values of your field.

For example:

load productid, Region where not match(Region,'EMEA','NAMR');

or you can load the Region names into a table and then use that field in Exists function in your where clause.

For example:

load productid, Region where not exists(MatchRegions, Region);

Not applicable

Re: How could the some of the field values be excluded and how the name of values could be changed?

But if I only want to exclude them when I design a chart, in other cases, perhaps I still need them?

sudeepkm
Valued Contributor III

Re: How could the some of the field values be excluded and how the name of values could be changed?

yes you can exclude the values in the Chart Dimension using a calculated dimension.

EDIT:

or in the chart expression using Set analysis

Not applicable

Re: How could the some of the field values be excluded and how the name of values could be changed?

The same method as you mentioned earlier?

sudeepkm
Valued Contributor III

Re: How could the some of the field values be excluded and how the name of values could be changed?

no it will be at the front end objects like charts not in script.

when you create a chart you can restrict the charts data as per a condition such as Region = EMEA and NAMR.

Can you also explain your requirement a little bit more then I can provide a sample.

Not applicable

Re: How could the some of the field values be excluded and how the name of values could be changed?

For example, if I have a field named component with value a, b, c, d, e, f, and g. I would like to only have value a, b, c, d in my field component to be a dimension in a line chart. How can I set the condition?

sudeepkm
Valued Contributor III

Re: Re: How could the some of the field values be excluded and how the name of values could be changed?

please take a look at the example. I've created two charts in one you can restrict the values of a Field in the dimension and in another chart you can restrict the field values in expression using set analysis.

Not applicable

Re: How could the some of the field values be excluded and how the name of values could be changed?

Goto dimension instead of adding dimension use add calculated dimension available in right side give your condition there.

On what condition you want to select the values??