topic Re: Re: Dash in graphs in QlikView

Dash in graphs

Tue, 22 Apr 2014 22:09:07 GMT

Hi, as no googling and searching helped, I would like to ask for suggestions how to solve my issue.

I have one simple excel table with sales data from 2012-today that I load into QV and filter by time, segments, customers.

There is one column graph that is meant do display the sales for the selected subsegment over the whole period the data is provided for.

I have three dimensions: Year, Month, and a "dummy dimension" =1 as suggested elswere on the forums to force Year and Month on the X axis. The expression is simple Sum(Sum)

- I have created a master calendar and linked it to the original table in order to fill in the missing months/years (which might have not been necessary if I select "Show all values" in Chart Properties > Dimensions > Month, and ... > Year as the dataset contains all the values)

- I have unchecked the Supress Zero-Values in the Chart Properties > Presentation tab in order to see columns for all the months

- I have unchecked the Supress Missing option even though it doesn't seem to have effect on the graph.

- I have doublechecked both tables in the table view preview to make sure there are no missing values in the Date column

Problem:

I can't get rid of the "dash" that appears in addition to all the month and years values and suggest there are some NULL values in both tables (which I'm not aware of)

This is probably going to be a very stupid problem...

Sorry, I can't attach the QV file as I'm still evaluating the app in the personal edition.

Re: Dash in graphs

swuehl — Tue, 22 Apr 2014 22:22:00 GMT

Even if you are using the personal Edition, everybody with a license can open your app.

Have you tried suppressing Nulls on dimension tab?

Re: Re: Dash in graphs

Thu, 24 Apr 2014 12:15:43 GMT

Hi, thanks for the suggestion, but as soon as I tick the checkbox, I'm note getting the full timeline in the graph (upper right).

When the checkbox is unchecked, I get the full timeline, but also I get the extra dashes after dec and after 2014.

I would like to keep the timeline fixed, so that it makes visual comparison easy when switching between the companies by clicking the left-hand bar graph rows.

I have attached an anonymized version of the file. Wasn't aware that this will be possible...

Once again, I appreciate your help.

Re: Dash in graphs

Thu, 24 Apr 2014 12:47:50 GMT

Why do you set 1 as a dimension,what do you want to achive with this dimension?

Re: Dash in graphs

Thu, 24 Apr 2014 12:52:47 GMT

Hi, I wanted to have both year and month on the X axis with them being in "two levels" so I followed this advice: Show two dimensions on x-axis of a chart

Is it a "wrong way"?

Re: Dash in graphs

Thu, 24 Apr 2014 12:56:56 GMT

Try Suppressing Null Values for both Year and Month. (Attached) You may be only suppressing the Month.

Re: Dash in graphs

Thu, 24 Apr 2014 13:02:07 GMT

Sorry, I can't open the file as I have the personal addition only.

But if I suppress the null values, this is what I get (i.e. for Company137) - the timeline is gone

Re: Dash in graphs

Thu, 24 Apr 2014 13:12:42 GMT

You can Suppress Nulls only for Month, but 2014 will appear as '-'.

As for the attachment, you are the original Author and I think you should be able to open it.. please try and let me know if I'm wrong

Re: Dash in graphs

sudeepkm — Thu, 24 Apr 2014 13:12:46 GMT

can you please share the [Shop-revenues.xls] file for verification purpose?

Re: Re: Dash in graphs

Thu, 24 Apr 2014 13:19:15 GMT

Hi, no problem... File is in the attachment. Thanks!

Re: Re: Dash in graphs

Thu, 24 Apr 2014 13:22:47 GMT

Hi, this is what I'm getting.

Not being able to open other files created with my current user key would be a disaster

I could... I don't care so much about getting the extra dash for months values, but the extra empty area created by the year dash takes up a whole lot of space...

Re: Dash in graphs

Thu, 24 Apr 2014 13:24:51 GMT

Don´t open. After 5 of this you can´t use qv.

Re: Dash in graphs

sudeepkm — Thu, 24 Apr 2014 13:53:48 GMT

I tried loading the data from the xls and found that your script is fine. I created a bar chart and found this as below.

Is this something how you want this chart to be displayed. I didn't use the "Show All Values" option.

Re: Dash in graphs

Thu, 24 Apr 2014 14:16:39 GMT

Yes, exactly, this is how I want it to look.

When you select Company137 with your curent settings, does it still display all the months for jan 2012 - dec 2014 although there are values just in jun 2013 and feb 2014? Because that what I was trying to achieve, but I was always getting either the full timeline + dashes, or only individual months.

Thanks!

Re: Dash in graphs

Mon, 22 Feb 2016 08:27:09 GMT

Had the same problem, this article shows you how to fix it!

https://community.qlik.com/docs/DOC-7941