Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
antwnina
New Contributor III

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

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)

)

3 Replies
Partner
Partner

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

You can overlap one chart over another making background transparent.

antwnina
New Contributor III

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

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

antwnina
New Contributor III

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

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