topic Re: Reverse Bar Chart in QlikView

Reverse Bar Chart

Tue, 31 Jul 2012 19:03:23 GMT

I have the attached bar chart, as you can see for different groups (the dimension) I am showing incidence of some products (the expressions)

I would like to create another version of this chart - in which the produts are the dimension and the groups are the expression

In excel this will be just switching row and columns.

It may be that the problem is my data (I a not working from product level data, I have suimmarized data from my database that has one a column per product with a 1/0 flag per customer, this seems simpler to me and it has worked so far)

is there a way to based the chart on a pivot or table, if so how (this may work)

is there a magial option to just flp the chart like on excel?

Thanks for any help

Mario

Re: Reverse Bar Chart

Wed, 01 Aug 2012 07:24:20 GMT

can you post a sample qvw file?

it'l be much easier

Re: Reverse Bar Chart

Thu, 02 Aug 2012 13:22:14 GMT

Thanks for your help.

I do not know how to post a sample file, I guess I could figure it out

it is not an issue of demoting, it is of makign the expression the dimension and vice versa. The more I think about it has to do with the data I am feeding qview, it has aready been pre-summarized so I do not have a varibale that says what products one own, I have idnividual flags for each product of interest

I was hoping that I could do a char based on a chart or pivot - do yo know if that is possible, as at that point it would be sinmpler with the existign data

Re: Reverse Bar Chart

Thu, 02 Aug 2012 13:22:35 GMT

Thanks for your help.

I do not know how to post a sample file, I guess I could figure it out

I was hoping that I could do a char based on a chart or pivot - do yo know if that is possible, as at that point it would be sinmpler with the existign data

Re: Reverse Bar Chart

Thu, 02 Aug 2012 13:43:56 GMT

can you make those two barcharts in excell ald send a file or snapshot?

Re: Reverse Bar Chart

Thu, 02 Aug 2012 13:54:30 GMT

if you'd like to add a file - use "advanced editor" (or if you want to add a file to previously added post - use "Edit" option)