Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vidyasagar159
Contributor

Multi Dimension Columns in QLIK SENSE Bar Charts

Hi All,

Hope you guys are doing fantastic. I have a simple requirement . How to Create Multi Dimension Bar chart with the sample data below.

   

YearProductAmount
2010Apple10
2011Apple20
2012Apple30
2010Bat50
2011Bat60
2012Bat70
2010Cake15
2011Cake20
2012Cake25

Bar Chart should look like this Qlik Sense.

Y- axis : Sum(Amount)

X-axis : 1. Year

             2. Size.

"Size"  is a Dimension expression which is :

=if(Aggr(Sum(Amount),Year,Product)>50 ,'Greater Than $50',

if(Aggr(Sum(Amount),Year,Product)<=50 ,'Less Than $50',

if(Aggr(Sum(Amount),Year,Product)>100,'Greater then $100' )))

Color Legend: Product.

Issue I am facing is : There is no option to add 3 dimensional columns in Qlik sense. Maximum I can create only 2.

If we cant achieve the same bar chart what would be the alternate solution for this?.

Thanks in advance.

-Vidya

3 Replies
pablolabbe
Valued Contributor II

Re: Multi Dimension Columns in QLIK SENSE Bar Charts

Bar charts only allows you to use 2 dimensions as max with one measure. Unfortunately, this kind of chart is not possible with the native object. Maybe try to review the way you visualize the data.

By the way, the sample image was generate by which software ?

Kind Regards,

Pablo

vidyasagar159
Contributor

Re: Multi Dimension Columns in QLIK SENSE Bar Charts

Thanks for the Quick response Pablo. Got it I will try different options. The Bar chart which I have attached is from Tibco Spotfire BI tool.

Thanks,

-Vidya

pablolabbe
Valued Contributor II

Re: Multi Dimension Columns in QLIK SENSE Bar Charts

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.