Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wiz_nerd
Creator
Creator

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

Labels (4)
1 Solution

Accepted Solutions
sunny_talwar

This

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

View solution in original post

9 Replies
sunny_talwar

last value based on what kind of sorting?

wiz_nerd
Creator
Creator
Author

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

sunny_talwar

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

{<fieldX = {"<$(=Max(fieldX))"}>}
wiz_nerd
Creator
Creator
Author

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

sunny_talwar

Dimension

fieldA

Expression

Sum({<Fieldx = {"<$(=Max(Fieldx))"}>} FieldB)
wiz_nerd
Creator
Creator
Author

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

sunny_talwar

This

=If(Fieldx < Max(TOTAL Fieldx), fieldA)
wiz_nerd
Creator
Creator
Author

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.

sunny_talwar

Total value?