How to combine lines and bars in same chart without combo chart

Anonymous — Thu, 30 Nov 2017 08:54:34 GMT

Hello, I have the following problem. I want a chart where I want to compare some products of my store with products that I produce, where myProducts I want to represent them with lines and the other products with bars. I did this with my 3 product as a line and 1 product of a foreigner, but now I want to select more than 1 foreigner's products and not to lose the color pattern. To be more specifical

dimensions: Date, ProductName

expressions: myProduct1, myProduct2, myProduct3, =Only(ProductName)

I tried to just do it without my products and it is fine even if a product appears each time it has the same color

then I tried to put it all in one expression and I keep the coloring but I don't have the desired result where myProducts will be represented with lines and the foreigners' ones with bars

here is the expression

sum(

CalendarMonthYear = {"$(=Date(max(LinkTable.Date), 'MMM-YYYY'))"},

ChannelName -= {'myProduct1', 'myProduct2', 'myProduct3'}

ProductStatistics.Total)

sum(

CalendarMonthYear = {"$(=Date(max(LinkTable.Date), 'MMM-YYYY'))"},

ChannelName = {'myProduct1', 'myProduct2', 'myProduct3'}

ProductStatistics.Total)

)

(

count(

CalendarMonthYear = {"$(=Date(max(LinkTable.Date), 'MMM-YYYY'))"},

ChannelName -= {'myProduct1', 'myProduct2', 'myProduct3'}

distinct ProductStatistics.DateTimeReaded)

count(

CalendarMonthYear = {"$(=Date(max(LinkTable.Date), 'MMM-YYYY'))"},

ChannelName = {'myProduct1', 'myProduct2', 'myProduct3'}

distinct ProductStatistics.DateTimeReaded)

)

Re: How to combine lines and bars in same chart without combo chart

shraddha_g — Thu, 30 Nov 2017 08:59:18 GMT

You can overlap one chart over another making background transparent.

Re: How to combine lines and bars in same chart without combo chart

Anonymous — Thu, 30 Nov 2017 09:40:06 GMT

it want be efficient in selections
is there anything in scripting or macro??

Re: How to combine lines and bars in same chart without combo chart

Anonymous — Thu, 30 Nov 2017 10:09:46 GMT

also, the problems with that are:

1) the chart will be too big on the x-axis and the scrolling bar won't be good

2) if I will overlap the line chart so they will be visual continuously must be in the front but by that, if I want to select a bar I won't be able to do it

despite tint the size of the are

topic How to combine lines and bars in same chart without combo chart in QlikView

How to combine lines and bars in same chart without combo chart

Re: How to combine lines and bars in same chart without combo chart

Re: How to combine lines and bars in same chart without combo chart

Re: How to combine lines and bars in same chart without combo chart