Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

Mini Chart Complexity

 

Hello All,

Is there any way to make below table, can some one pls suggest.

 

priyarane_0-1620028471706.png

 

6 Replies
JuanGerardo
Partner - Specialist
Partner - Specialist

Hi @priyarane, you can use the minicharts:

JuanGerardo_0-1620044201051.png

 

JG

priyarane
Specialist
Specialist
Author

Hi Juan, thanks for your time.

I need a layout as specified above. Sales and Count need to be aligned.

 

priyarane
Specialist
Specialist
Author

Is there any way to bring that template?

 

MadiF
Contributor III
Contributor III

@priyarane It doesn't appear to me that you'll be able to achieve that exact layout, seeing as the mini chart option is only available in a straight table, but to get the measures as rows like you're hoping to, you have to use a pivot table. I think your best shot is making a straight table with Country as a column.

JuanGerardo
Partner - Specialist
Partner - Specialist

If your country number is fixed, you can create a sheet with 4 KPIs and 2 line charts. If not, you can create a pivot table with the numbers and use a trellis container to have different line charts for every country.

JG

priyarane
Specialist
Specialist
Author

Thank you all for your responses