Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Dhirendra_Kharwar_13373

Two Dimensions and Two Measures required in Chart

Hey Guys! Greetings.

I have to need the Two measures and two dimensions in the chart like below,

I have the Fiscal year and Company name for Dimension and the Amount and CAGR as a measure

 

like the below chart.

Dhirendra_Kharwar_13373_0-1649069134356.png

In the above chart

A, B, C, D.... etc are the companies names and Bars are showing the Fiscal years, and also there are two measures i.e. Sum(Amount), CAGR.

Hight of Bars is Sum(Amount) and line is CAGR.

 

Please help me to solve this problem, and suggest to me any Chart in the QlikSense or extension in which I can use two dimensions and two measures.

 

Labels (1)
5 Replies
SunilChauhan
Champion II
Champion II

Combo chart  should best suited to this chart

Sunil Chauhan
Dhirendra_Kharwar_13373
Author

Hi, dude thank you for your reply, I tried but it's not working,

I have no need for alternative dimensions or measures for it. So the combo is not working.

if you have details then help, please.

Ily
Contributor II
Contributor II

Hello @Dhirendra_Kharwar_13373  did u find the solution ? I'm interested also ? Any extension ? 

vinieme12
Champion III
Champion III

Use a Combo Chart with One Dimension and Two Measure

The Dimension should be a Calculated Dimension as Below

=Aggr(Company&'-'&Year,Company,Year)

You wouldn't want legends though

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Ily
Contributor II
Contributor II

There is no extension for this ?