topic Change a bar chart to group by expression rather than dimension in QlikView

Change a bar chart to group by expression rather than dimension

Anonymous — Tue, 20 Apr 2010 18:20:47 GMT

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

Change a bar chart to group by expression rather than dimension

Tue, 20 Apr 2010 23:52:20 GMT

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

Change a bar chart to group by expression rather than dimension

Anonymous — Wed, 21 Apr 2010 18:45:44 GMT

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.

Change a bar chart to group by expression rather than dimension

Tue, 15 Mar 2011 20:27:20 GMT

I have the same problem, but I did not see an answer. Was an answer provided for this?

Thanks

Change a bar chart to group by expression rather than dimension

Tue, 15 Mar 2011 20:45:16 GMT

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