topic Re: Dual Dimension with Static Min Max Step in QlikView

Dual Dimension with Static Min Max Step

Fri, 24 Feb 2012 11:16:40 GMT

Hi there,

I have problem to contruct a bar chart displaying text value of a dual dimension which consists of category values ('Low', 'Medium', 'High') with ranking (1, 2, 3) on the x-axis. I would like to x-axis always show 'Low', 'Medium', 'High' even though my data only contain 'Low'. I thought I set the Static Min, Max, Step to 1, 3, 1 to resolve the issue. However, when I set static Min, Max and Step, the x-axis only show only the numeric ranking value not the text.

I wonder is there anyone can shed some light on my problem.

Many thanks in advance,

Eric.

Dual Dimension with Static Min Max Step

CELAMBARASAN — Fri, 24 Feb 2012 11:23:05 GMT

Hi,

Check Show all values option for that dimension in the Dimension tab of the Chart Properties.

Celambarasan

Dual Dimension with Static Min Max Step

Fri, 24 Feb 2012 11:29:24 GMT

Hi Celambarasan,

Thanks for your reply. But the chart contains only 'Low' category and not have any 'Medium' or 'High' data even I have selected "Show all value" option though.

Eric.

Dual Dimension with Static Min Max Step

jvitantonio — Fri, 24 Feb 2012 11:30:52 GMT

Can you upload ur app?

Dual Dimension with Static Min Max Step

CELAMBARASAN — Fri, 24 Feb 2012 11:34:40 GMT

Hi,

Did you tried by unchecking

Suppress zero values.

Suppress null values.

Suppress missing values in presentation tab.

Dual Dimension with Static Min Max Step

jvitantonio — Fri, 24 Feb 2012 11:36:21 GMT

Otherwise, go to the chart properties. Go to tab Presentation and uncheck "Supress Zero-Values"

Dual Dimension with Static Min Max Step

Fri, 24 Feb 2012 11:43:52 GMT

Hi Celambarasan and Qlikuser14,

Thanks guys!

I have unselected "Suppress When Value Is Null" and selected "Show All Values" in Dimension tab and unselected "Suppress Zero-Values" and unselected "Suppress Missing" options in the Presentation too.

I will construct a small qvw to show my problem.

Eric

Re: Dual Dimension with Static Min Max Step

Fri, 24 Feb 2012 12:49:52 GMT

Here my simplified exampl

Re: Dual Dimension with Static Min Max Step

jvitantonio — Fri, 24 Feb 2012 13:05:13 GMT

Eric, there's a problem with your design. Right now, it works as designed. You need to create a seaparate table with the 3 descriptions (High, Medium, Low). This will be your dimension. Check this out.

Re: Dual Dimension with Static Min Max Step

Fri, 24 Feb 2012 13:32:18 GMT

Hi qlikuser14,

Thanks for your reply. Yes, may be I should change the schema. My goal in the Water Score Chart is to show all bars (Low, Medium, High) and Low with 0 spend (this is my problem to show this bar) and Medium with 23 spend and High with 21 spend in ascending order. The missing is WaterScoreDesc belong to the Carbon Score ideally should not display in the Water Score Chart.

Eric.

Dual Dimension with Static Min Max Step

jvitantonio — Fri, 24 Feb 2012 13:45:26 GMT

Ok, as shown in my app. you can do it by adding that table. I hope I was helpful

Re: Dual Dimension with Static Min Max Step

Fri, 24 Feb 2012 14:19:55 GMT

Hi qlikuser14

I see you mean create another table for Low, Medium, High as a lookup that link to the Test table.

Many thank qlikuser14!