Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to add no of coy line chart into my existing chart 2 ?

Hi All

I have chart 1 . ( no of company by year )

I like to add chart 1 chart into chart 2. ( no of invoice and net profit )

In Conclusion , i need the chart 2 Add with Table 1 line chart.

So that i can have 3 chart display at chart 2.

Hope some one can help me.

Paul

7 Replies
avinashelite

you could directly add them as expression rite??

try like this

1.Add Year as the dimension

2.Add count(company) , count(invoice) and sum([net profit]) as the expressions

paulyeo11
Master
Master
Author

‌Hi Sir

my issue is chart 2 you notice that for count(inv) and sum(nET_PROFIT) , the Y Axis scale is different. When I add count(company) it take the count(inv) , which make the company value too small unable to display at chart 2.

my objective is to make all 3 field display clearly on chart.

PAul

avinashelite

In that case you need to make use of 2 different chart that would better because if the value have huge difference than we can't show properly ...

OR

show the expression conditional i.e create a inline table with value company count, net profit etc and based on the selection conditional enable the expression(in could see this option in the expression tab) ...

paulyeo11
Master
Master
Author

Hi Sir

I think QS should be able to do it. it is just that i cannot figure how to make it work. need some expert help to advise me.

Paul

avinashelite

Hmmm try checking Force 0 in the presentation tab or increase the  height of the chart , this might help you to certain extent .

When two values have a huge difference obviously one value will appear large and another small  Qliksense will handle the scale automatically ...

paulyeo11
Master
Master
Author

Hi sir

Does it mean that QV Or QS only allow to have 2 set of Y Axis scale ?

If it allow have more then 2 sets then it will able to solve my issue.

Paul

Sent from my iPhone

avinashelite

yes your right