Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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);
But if I only want to exclude them when I design a chart, in other cases, perhaps I still need them?
yes you can exclude the values in the Chart Dimension using a calculated dimension.
EDIT:
or in the chart expression using Set analysis
The same method as you mentioned earlier?
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.
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?
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.
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??