topic Re: Chart axes changes from 100% to 1.0 on selection in QlikView

Chart axes changes from 100% to 1.0 on selection

tom2qlik — Fri, 30 Jun 2017 09:43:53 GMT

Hi All,

I tried to create a mock QVW but couldn't replicate what I have in my main QVW.

I have a combo chart bar/line with axes totalling 100% Overall it's fine and looks how it should. However when I click on a date which does not have a line value the axes changes from 100% to 1.0. Below is the chart without selections.

The bars are stacked to 100% which is perfect and the lines also show as a percentage.

The problem occurs when I click on a date without a Total field value. For this example I click on dates Aug 16 and Sep 16.

You'll see the axes changes now to 1.0 instead of 100%.

Each bar expression looks like the following for it's respective field.

[<10]/(sum([<10])+sum([<100])+sum([100-1000])+sum([>1000]))

The "thin" and "total" expressions are just calling the field value which is between 0-1.

I have selected in the number tab "show in Percent (%)" .

Any ideas?

Thanks,

Tom

Re: Chart axes changes from 100% to 1.0 on selection

kaushiknsolanki — Fri, 30 Jun 2017 09:50:47 GMT

Hi Tom,

It will be difficult to help you without looking at the application.

If possible share your app.

Regards,

Kaushik Solanki

Re: Chart axes changes from 100% to 1.0 on selection

tom2qlik — Fri, 30 Jun 2017 10:20:02 GMT

Here is a sample qvw.

Re: Chart axes changes from 100% to 1.0 on selection

kaushiknsolanki — Fri, 30 Jun 2017 10:24:43 GMT

Hi Tom,

I checked all possible selections and i cant see the axis changing to 1

Regards,

Kaushik Solanki

Re: Chart axes changes from 100% to 1.0 on selection

tom2qlik — Fri, 30 Jun 2017 10:29:37 GMT

Hi Kaushik,

Select a date like shown below and it will change to 1.

Thanks,

Tom

Re: Chart axes changes from 100% to 1.0 on selection

kaushiknsolanki — Fri, 30 Jun 2017 10:32:43 GMT

Check this. The axis is still the same.

Regards,

Kaushik Solanki

Re: Chart axes changes from 100% to 1.0 on selection

antoniotiman — Fri, 30 Jun 2017 10:41:40 GMT

Hi Tom,

this is behavior QV 11.20.

OK in 12.10.

Regards,

Antonio

Re: Chart axes changes from 100% to 1.0 on selection

tom2qlik — Fri, 30 Jun 2017 10:41:52 GMT

Not for me

I'm using the same qvw as you.

Re: Chart axes changes from 100% to 1.0 on selection

kaushiknsolanki — Fri, 30 Jun 2017 10:43:07 GMT

What version you are using?

Regards,

Kaushik Solanki

Re: Chart axes changes from 100% to 1.0 on selection

antoniotiman — Fri, 30 Jun 2017 10:43:29 GMT

QV 12.10

QV 11.20

Re: Chart axes changes from 100% to 1.0 on selection

tom2qlik — Fri, 30 Jun 2017 13:25:13 GMT

Thanks Antonio