topic Re: Diagram / chart doesn't show all values in QlikView

Diagram / chart doesn't show all values

Anonymous — Wed, 24 Apr 2013 14:13:51 GMT

Hello dear community

I have the following problem:

I want to show all avail. data in a diagram !without! using the continuous funktion or scrolling of the x-axis.

Re: Diagram / chart doesn't show all values

Anonymous — Mon, 06 May 2013 09:34:40 GMT

Somebody , anybody

I see that the imges are somehow not visible.

Here is what i mean:

I really don't know how to solve this problem. Please HELPP!!!!!

Re: Diagram / chart doesn't show all values

Gysbert_Wassenaar — Mon, 06 May 2013 09:48:33 GMT

You need to add the missing dates in your date dimension with something like this:

MinMaxDate:
Load Min(Date) as MinDate, Max(Date) as MaxDate resident MyTable;
Let vMinDate = Peek('MinDate',-1,'MinMaxDate') - 1;
Let vMaxDate = Peek('MaxDate',-1,'MinMaxDate') ;

Drop Table MinMaxDate;

Join (MyTable)
Load Date(recno()+$(vMinDate)) as Date Autogenerate vMaxDate - vMinDate;

Replace MyTable with the table containing your date field and Date with the name of your date field.

Once all the missing dates are added your table you can disable the option Suppress Zero-Values on the Presentation tab in your chart.

Re: Diagram / chart doesn't show all values

Anonymous — Mon, 06 May 2013 10:00:25 GMT

I thought also about this possibility.

But I have appx. 500 000 000 raws in my table.

To join the data with a calender I would have not only to create missing dates but also hours, minutes and maybe seconds.

That would increase 'a lot' the script execution time....

Or am I wrong??

cheers chesterluck

Re: Diagram / chart doesn't show all values

Gysbert_Wassenaar — Mon, 06 May 2013 12:55:43 GMT

That's right. So use a continuous x-axis instead if you want to show hours and minutes. If showing averages (or totals) per day is good enough, split the datetime field into a date and a time field and generate the missing dates for the date field.

Re: Diagram / chart doesn't show all values

Anonymous — Mon, 06 May 2013 13:52:13 GMT

Well therefore I wrote the thread. Look:

- the continuous scale is fine but the empty values are problematic

- Nor using the continuous scale would be also fine when not the x scroll bar.

- The option with suppressing Zero values (your 1st advice) is proplematic as I would have to create a calender with dates / hours / minutes / seconds = high script execution time....

So if there is no possibility I will probably have to export the data to an excel template an use a pivot chart in excel.

I honestly cant understand why QV is not supporting these kind of functionlities. Anyway thank you very much Gysbert.

Re: Diagram / chart doesn't show all values

swuehl — Mon, 06 May 2013 14:11:58 GMT

chesterluck,

if you absolutely want to show all your data in the chart (like option 2 'Nor using the continuous scale would be also fine when not the x scroll bar.'), that should be possible.

See attached for a sample with 10000 data points. Of course you would need to 'zoom in' (i.e. select a sub-range of data) to see the datapoints in detail, i.e. there is a loss of information in this view.

Regards,

Stefan

Re: Diagram / chart doesn't show all values

Anonymous — Mon, 06 May 2013 15:06:28 GMT

unbelieveable it worked. I was using a line diagram, but had to use a combi diagram instead. Stefan can you explain why and how it makes a difference.

Already 1000 thanks to both experts

Cheers chesterluck

Re: Diagram / chart doesn't show all values

Thu, 12 Sep 2013 10:19:11 GMT

I've been struggling with this and was happy to find a solution - but I can't get it to work! I've downloaded the document and tried to make a similar chart as the one already there - but my version does NOT display all values. What am I doing wrong? How did you guys manage to get it to show all values?

Re: Diagram / chart doesn't show all values

Anonymous — Thu, 19 Sep 2013 07:59:48 GMT

Can you upload your file so i can have a look

Re: Diagram / chart doesn't show all values

Thu, 19 Sep 2013 08:12:17 GMT

Thanks; I’m not sure how you upload files to the Community, but I’m giving it a try.

Re: Diagram / chart doesn't show all values

Anonymous — Fri, 20 Sep 2013 12:01:23 GMT

I dont really get the problem. In the file everything is shown already. The first diagramm is correct. the second not.

the difference are the following properties in the presentation part: Check the 2 checkboxes on the left :

Striche als Balken zulassen and Alle Balken anzeigen.

So in english sth like allow lines as bars and show all bars. Dont forget to use the Combidiagramm on first prop tab. cheers chesterlcuk

Re: Diagram / chart doesn't show all values

Fri, 20 Sep 2013 12:10:27 GMT

That is absolutely fantastic! I’m not sure how I missed that... Made my day!

Re: Diagram / chart doesn't show all values

Anonymous — Fri, 20 Sep 2013 12:41:30 GMT

Your welcome