topic Re: qlik sense chart without dimension in Visualization and Usability

qlik sense chart without dimension

ottebian — Fri, 15 Jan 2016 10:10:47 GMT

Hi,

I'm currently reviewing Qlik Sense and I try to rebuild a dashboard, we already have in use with QlikView.

Therefore I need to build a Pie-/Donutchart that contains serveral Expressions but NO dimensions.

I find myself failing to create such a Chart, and hope anyone can help out.

regards

Re: qlik sense chart without dimension

vinay_hg — Fri, 15 Jan 2016 11:12:14 GMT

HI Even in QlikView U should have 1 dimension right? same way here. anyway please share the eeg of wat you have done in QlikView so it will give us a better understanding or at least an eg.

Re: qlik sense chart without dimension

ogster1974 — Fri, 15 Jan 2016 11:38:09 GMT

How would the pie chart know what to segment by without a dimension?

I think as vinaykumar suggests a screen shot would help to show what you are looking to achieve and allow people to offer solutions.

Re: qlik sense chart without dimension

ottebian — Fri, 15 Jan 2016 12:02:18 GMT

First, thank you for your answer.

I don't have a screenshot at hand right now, but I found a blog Post that addresses this topic and shows what I am trying to achieve: Expressionless and Dimensionless Charts | Qlikview Cookbook

Re: qlik sense chart without dimension

Fri, 15 Jan 2016 12:11:16 GMT

perhaps add an expression as:

=''

has an "expression" but title would be blank and would cover all (~filtered) data

Re: qlik sense chart without dimension

ogster1974 — Fri, 15 Jan 2016 12:13:09 GMT

So you are looking to visualise a value that has been calculated and perhaps displayed in a KPI already.

In that case you would need to create a dynamic dimension as a master item I think.

Something like

=ValueList('Sales','Margins')

Then in your measure would be something like

If( <your dimension> = {'Sales'}, <your sales calc>, <your margin calc>)

Re: qlik sense chart without dimension

vinay_hg — Fri, 15 Jan 2016 12:17:39 GMT

then You can use Gage chart or KPI's chart or text objects for the same. but not the Pie chart.

Re: qlik sense chart without dimension

ogster1974 — Fri, 15 Jan 2016 12:22:13 GMT

Attached is a working example of this approach

What is ValueList? see if it will work for your case.

Re: qlik sense chart without dimension

ottebian — Fri, 15 Jan 2016 12:33:23 GMT

Thank you all very much for your help.

Combining some of your answers I found a way to make my chart work. It looks a little different from what I had in mind beforehand, but it meets the users requirements just as well. Thanks alot.

Re: qlik sense chart without dimension

ogster1974 — Fri, 15 Jan 2016 14:41:34 GMT

‌let us know how you solved it as it might be a useful solution for other community members.

Re: qlik sense chart without dimension

reddy-s — Fri, 15 Jan 2016 20:24:52 GMT

Hi OTTEBIAN,

You can even build your own visualisation if you want to visualise it the way you want.

Thanks and Regards,

Sangram Reddy.

Re: qlik sense chart without dimension

rwunderlich — Fri, 15 Jan 2016 22:14:45 GMT

Pie Chart consisting of only expressions is valid in QlikView, but apparently not allowed in Sense. I'm not sure why not.

-Rob