topic Re: Problem with graph in QlikView

Problem with graph

Anonymous — Wed, 16 Dec 2015 11:35:32 GMT

Hello everybody,

I have a litle query. I'm doing a graph and I like to show all the values of my count(ID). Sometimes this operation is 0 and I need to show all the values, although this has been 0.

I do a graph of lines with all dates of a year.

¿Is it possible?

I hope any suggestion

Sorry for my bad English....

Re: Problem with graph

Anonymous — Wed, 16 Dec 2015 11:39:34 GMT

What exactly you want?

You can try like this:

=Count(distinct ID)

Re: Problem with graph

MK_QSL — Wed, 16 Dec 2015 11:40:39 GMT

go to presentation tab

untick suppress zero values

Re: Problem with graph

Anonymous — Wed, 16 Dec 2015 11:46:59 GMT

Hello,

I want to show all the dates although count(ID) = 0

Example

1/1 count(ID) = 0

2/1 count(ID) = 5

3/1 count(ID) = 6

4/1 count(ID) = 0

5/1 count(ID) = 8

I need to paint the 5 values, although 2/5 are 0

¿it is possible?

Re: Problem with graph

Anonymous — Wed, 16 Dec 2015 11:52:20 GMT

any sample data?

Re: Problem with graph

Wed, 16 Dec 2015 11:54:19 GMT

Go to Chart properties and Presentation Tab.

Untick Supress Zero Values.

Tick Zero on Bars.

In Dimensions tab,

Select Dimension and Tick Show All Values.

Regards,

Anjali Gupta

Re: Problem with graph

Anonymous — Wed, 16 Dec 2015 12:22:05 GMT

Hello,

This is a example of graph. Count(ID) of the days: 7,9,10,11,12, etc is 0, by this reason the graph don't show the values of day

I unckeck suppress zero values, but this don't work

¿Any suggestion more?

Re: Problem with graph

MK_QSL — Wed, 16 Dec 2015 12:26:30 GMT

Provide sample data please..

Re: Problem with graph

Wed, 16 Dec 2015 13:19:07 GMT

Try This:

Go to Chart properties and Presentation Tab.

Untick Supress Zero Values.

Tick Zero on Bars.

Re: Problem with graph

Anonymous — Wed, 16 Dec 2015 13:27:29 GMT

Hello,

I add an example with my trouble. I have all days in November but I don't have ID all the days. I like show all days although count(ID) = 0

Example :

1/11 --> count(ID) = 2

4/11 --> count(ID) = 3

12/11--> count(ID) = 0

13/11-->count(ID) = 0

14/11->count(ID) = 0

Re: Problem with graph

MK_QSL — Wed, 16 Dec 2015 13:32:20 GMT

Like this?

Re: Problem with graph

Anonymous — Wed, 16 Dec 2015 13:39:46 GMT

Sorry, but I have Qlikview Personal Edition and I can't open files of other users. Can you add a image and say me the changes?

Re: Problem with graph

florentina_doga — Wed, 16 Dec 2015 13:48:58 GMT

and sort ascending

page sort numeric value ascending