Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 questions in the attached simple qvw, question 2 being more important. I basically need to have several input items for the users to dynamically change, which then affect the expressions in my straight chart for the applicable dimension value. Ideally I'd love to have everything in the load script but so far this is the only way I've thought of to accomplish the chart you see in this qvw. What I can't seem to figure out is how can I get a column totals for expressions built from other expressions without creating massively long code in an expression (as would be the case in my real app). Any suggestions are appreciated, thanks.
I need column totals not row totals. I meant to attach an updated qvw and forgot, so I've done that here...this should help explain it. I did get help from another discussion on this that got me a little farther. I was able to use sum(aggr()) for all the expressions, and then use the column label names in later expressions with the Total Mode property of the expression set to Sum of Rows, and that gave me totals within the chart.
You can simply refer to the columns in the straight table by their labels and do calculations on them.
I need column totals not row totals. I meant to attach an updated qvw and forgot, so I've done that here...this should help explain it. I did get help from another discussion on this that got me a little farther. I was able to use sum(aggr()) for all the expressions, and then use the column label names in later expressions with the Total Mode property of the expression set to Sum of Rows, and that gave me totals within the chart.