Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist III
Specialist III

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

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

sudeepkm
Specialist III
Specialist III

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

The same method as you mentioned earlier?

sudeepkm
Specialist III
Specialist III

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

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
Specialist III
Specialist III

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

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??