Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does anyone know of a way to change a QlikView bar chart to group the bars by expression rather than dimension?
My chart has one dimension (Size -- small, medium, large) and five expressions. The expressions are based on five different True/False fields in my data. For each record I have a one Size value and five T/F values. Each of the five expressions reports the percentage of True records. The chart displays 15 bars in three dimension groups but I need to display the 15 bars in five groups, one group for each expression field.
Any ideas on how to accomplish that in a single chart?
Thanks, Mike
You can use expressions as calculated dimensions and dimension as expression to display only values.
if you could share some sample application / report with dummy data that will help me to understand well and give you more accurate solution.
Regards
Rajesh
I've attached an example QV document.
In the document you can see I have three groups defined by my Size field (Small, Medium, Large). I expect differences between attibutes (Q7a-e), but what I need to highlight for the user is whether Size is stongly related to the percentage for each attribute. What I need, then, are five groups -- one for each attribute.
Thanks for taking a look at this.
I have the same problem, but I did not see an answer. Was an answer provided for this?
Thanks
I suggest you to crosstable your file
CrossTable( Question, Response , 2)
LOAD Size,
RecNo,
Q7b,
Q7a,
Q7d,
Q7c,
Q7e
FROM yourfile
Then you can create chart for each question :
dimension : Question , Size,
expression : sum(Response) for example
JJ