Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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) ...
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
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 ...
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
yes your right