9 Replies Latest reply: Mar 9, 2015 8:49 AM by kiran ch

# Can we create bar charts in Qlik Sense with only measures without Dimensions

Hi all,

I am a new user of qliksense desktop and I am going through the pdfs given by Qliksense like Concepts in Qliksense I found that it is required in a bar chart to atleast one dimension and one measure. I am not sure why Qliksense came to that conclusion but is there any way that we can create bar  or line and bar with only measures.

Thanks

Kiran

• ###### Re: Can we create bar charts in Qlik Sense with only measures without Dimensions

Bar and line charts need a y and x-axis to work properly, so you always need 2 fields to create it.

• ###### Re: Can we create bar charts in Qlik Sense with only measures without Dimensions

Hi James,

Thanks for your time, my concern is in Qlik View we are able to create bar charts only with expressions and it solves some of the tasks where we don't want to use any dimension, I think it would be better if we have the same feature here also.

Thanks

• ###### Re: Can we create bar charts in Qlik Sense with only measures without Dimensions

Hi Kiran, have you thought about using the Gauge chart object?

This allows you to use only the measure without the dimension.

Also, since you are new to Qlik Sense - did you see these videos:

New to Qlik Sense Videos

Let us know how you do.

Regards,

Mike Tarallo

Qlik

• ###### Re: Can we create bar charts in Qlik Sense with only measures without Dimensions

Mike,

In my case I'm trying to create a table without dimension, any suggestion? (In qlikview I can do this, actually I use it frequently)

Thanks,

Miguel

• ###### Re: Can we create bar charts in Qlik Sense with only measures without Dimensions

Thanks Michael,

It works fine for one measure but it doesn't for multiple measures.

• ###### Re: Can we create bar charts in Qlik Sense with only measures without Dimensions

You do have to add a dimension but perhaps the following example might help ?

Using a synthetic dimension ,  the dimension expression is as follows:   =valuelist('Sales','Costs')

And the Measure Expression is:  if ( valuelist('Sales','Costs') = 'Sales', sum(Sales), sum(Costs))

This will 'manufacture' the bars in the chart and then you conditionally assign a measure expression depending on the value of the manufactured expression.

Would this work ?

• ###### Re: Can we create bar charts in Qlik Sense with only measures without Dimensions

Thanks Jonathan,

Its working absolutely fine, but a small thing, actually in the expressions I want to use measures from master items using some if conditions but I couldn't do it but I have achieved it by rewriting the whole expressions in the if condition.

I thought QS alternative for dynamic variables is measures in master items but I am unable to use them in a if condition, correct me if I am work.

Thanks

• ###### Re: Can we create bar charts in Qlik Sense with only measures without Dimensions

Hi Kiran - the names of Master Items cannot be referenced by other calculations just yet.  You can define dynamic variables in the script . Just to make sure you use 'Set' in the script and invoke the variable in the expression using dollar sign expansion \$(variablename).

eg:

set variablename='sum(Sales)';

//---> expression is saved as a text string

usage:

if (  <condition> ,  \$(variablename) )

//---> the expression is inserted , not the string

• ###### Re: Can we create bar charts in Qlik Sense with only measures without Dimensions

Thanks jon,

For sure I will try this and let you know.