Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Restrict Field Value in line chart

Hello everyone

I come to know how to restrict field value in line chart.

I have 5 values in KPI but want to show only 4 values in line chart.

how restrict it?

Thanks.

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

If you want an expression that specifies what to exclude (and that can be hardcoded) instead of what to include, then you can use the reverse of that Set Analysis expression. For example, if I always want to exclude the Central Region:

=Count({<Region -= {'Central'}>} Investment)


which is another way to say: assign all currently selected values to Region in my temporary data set except for value Central.

View solution in original post

27 Replies
kakani87
Specialist
Specialist

Can you post some sample data

Anonymous
Not applicable
Author

Please find attached file

Anonymous
Not applicable
Author

I don't want to show data for Cetral Region.

kakani87
Specialist
Specialist

Check this

Restrict_FieldValues.png

Anonymous
Not applicable
Author

i am not able to open in personal edition. Plese share screenshot.

Thanks

kakani87
Specialist
Specialist

In chart add this expression

=Count({<Region={NE,SE,W}>}Investment)

Anonymous
Not applicable
Author

i dont want to do hardcoded. any other solution is there?

Anonymous
Not applicable
Author

I want to used in dimension not in expression

kakani87
Specialist
Specialist

Use this expression in list box instead of selecting a field

=if(match(Region,'NE','SE','W'),Region)