Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
last value based on what kind of sorting?
*********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.
May be just exclude the max(fieldX) from set analysis
{<fieldX = {"<$(=Max(fieldX))"}>}
could you please share the exact dimension expression or QVW because I have checked this is giving me error.
Dimension
fieldA
Expression
Sum({<Fieldx = {"<$(=Max(Fieldx))"}>} FieldB)
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??
This
=If(Fieldx < Max(TOTAL Fieldx), fieldA)
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.
Total value?