topic Re: How do I forcibly default a chart to display dimensions? in App Development

How do I forcibly default a chart to display dimensions?

Tue, 23 Feb 2016 19:51:26 GMT

In the example I've included, there are a number of dimensions missing because there are no measures occurring in that dimension. (2, 4, 5, 6).

For the sake of conversation, let's say this line chart counts how many individuals drop out of the process at each step. Let's call it a 12 step program. To do this, my chart is using Dimension =(STEPS), and Measure =COUNT(STEPS) How can I forcibly show that something (even a 0) happened at steps 2, 4, 5, & 6 even if nobody drops out of the process? Is there logic that I can enter into the Dimension that would show 1 2 3 4 5 6 7 8 9 10 11 12 on my chart, but still allow users to filter out any step that they would like?

Re: How do I forcibly default a chart to display dimensions?

kaushiknsolanki — Tue, 23 Feb 2016 20:01:30 GMT

Hi,

You can create another table which will have all the values and then you can use that field. For example.

Load STEPS, STEPS as Key From Data;

Load * inline [

Key, ALLSTEPS

1,1

2,2

.....

12,12

];

Now use the AllSTEPS field as dimension.

Regard,

Kaushik Solanki

Re: How do I forcibly default a chart to display dimensions?

Tue, 23 Feb 2016 20:22:46 GMT

Unfortunately, that doesn't work as other complex charts/visualizations are tied to that same field. It also doesn't appear to count correctly now.

Re: How do I forcibly default a chart to display dimensions?

Anonymous — Tue, 23 Feb 2016 21:00:43 GMT

Hi Isaac,

will something like this work?

Load * inline [

Step, DropOuts

1,1

2,0

3, 2

4, 0

5, 0

6, 0

7, 3

8, 2

9, 1

10, 2

11, 1

12,3

];

Then use "Step" as dimension, and DropOuts as measure.

Regards,

Muliady

Re: How do I forcibly default a chart to display dimensions?

kaushiknsolanki — Tue, 23 Feb 2016 21:01:08 GMT

Hi,

can you post the Qvf File.

Regards,

Kaushik Solanki

Re: How do I forcibly default a chart to display dimensions?

Anonymous — Tue, 23 Feb 2016 21:56:46 GMT

Try this: In the charts properties pane on the right, go to Appearance and expand Presentation. Here for missing values select 'Show as zeros'

Re: How do I forcibly default a chart to display dimensions?

Fri, 26 Feb 2016 14:36:45 GMT

unfortunately that's not an option for me. The root cause is that I'm using the same field for the dimension and measure, so Qlik doesn't even realize that steps 2, 4, 5, or 6 even exist in this sense.