# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
New Contributor III

## Considering N-1 values for chart dimension. Removing last 1 dimension value from barchart.

 fieldA Fieldx FieldB stringa 1 1 stringb 2 3 stringc 3 8 stringd 4 7 stringe 5 1 stringf 6 5 stringg 7 6 8 3 stringh 9 2 stringi 10 5

*********fieldA is string field and is not sortable and there is another field(FieldX) which is integer based on which I am sorting (fieldA)

I am creating a  bar chart but I want to consider N-1 values like i want to remove the last value here.

Stringi and only create the bar based on the rest of the values.

Labels (4)

• ### dimension

1 Solution

Accepted Solutions
MVP

## Re: Considering N-1 values for chart dimension. Removing last 1 dimension value from barchart.

This

`=If(Fieldx < Max(TOTAL Fieldx), fieldA)`
9 Replies
MVP

## Re: Considering N-1 values for chart dimension. Removing last 1 dimension value from barchart.

last value based on what kind of sorting?

New Contributor III

## Re: Considering N-1 values for chart dimension. Removing last 1 dimension value from barchart.

*********fieldA is string field and is not sortable and there is another field(FieldX) which is integer based on which I am sorting (fieldA)

MVP

## Re: Considering N-1 values for chart dimension. Removing last 1 dimension value from barchart.

May be just exclude the max(fieldX) from set analysis

`{<fieldX = {"<\$(=Max(fieldX))"}>}`
New Contributor III

## Re: Considering N-1 values for chart dimension. Removing last 1 dimension value from barchart.

could you please share the exact dimension expression or QVW because I have checked this is giving me error.

MVP

## Re: Considering N-1 values for chart dimension. Removing last 1 dimension value from barchart.

Dimension

`fieldA`

Expression

`Sum({<Fieldx = {"<\$(=Max(Fieldx))"}>} FieldB)`
New Contributor III

## Re: Considering N-1 values for chart dimension. Removing last 1 dimension value from barchart.

Is there a way to create the calculated dimension  based on Field x and fieldA  to remove the last FieldA because I don,t want to touch the measure expressions??

MVP

## Re: Considering N-1 values for chart dimension. Removing last 1 dimension value from barchart.

This

`=If(Fieldx < Max(TOTAL Fieldx), fieldA)`
New Contributor III

## Re: Considering N-1 values for chart dimension. Removing last 1 dimension value from barchart.

This solution looks perfect to the problem statement may you also tell me how to remove the total values in the end of the chart.

MVP

Total value?