Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
noobie_wiz
New Contributor III

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

fieldAFieldxFieldB
stringa11
stringb23
stringc38
stringd47
stringe51
stringf65
stringg76
 83
stringh92
stringi105

*********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.

Capture.PNG

1 Solution

Accepted Solutions

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

This

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

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

last value based on what kind of sorting?

noobie_wiz
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)

 

I have updated the question please check. Added one more field.

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))"}>}
noobie_wiz
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.

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

Dimension

fieldA

Expression

Sum({<Fieldx = {"<$(=Max(Fieldx))"}>} FieldB)
noobie_wiz
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??

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

This

=If(Fieldx < Max(TOTAL Fieldx), fieldA)
noobie_wiz
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.

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

Total value?