Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
antwnina
Contributor III
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
shraddha_g
Partner
Partner

You can overlap one chart over another making background transparent.

antwnina
Contributor III
Contributor III
Author

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

antwnina
Contributor III
Contributor III
Author

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