Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
tom2qlik
New Contributor III

Chart axes changes from 100% to 1.0 on selection

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

1 Solution

Accepted Solutions
antoniotiman
Honored Contributor III

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

Hi Tom,

this is behavior QV 11.20.

OK in 12.10.

Regards,

Antonio

10 Replies

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

Hi Tom,

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

If possible share your app.

Regards,

Kaushik Solanki

tom2qlik
New Contributor III

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

Here is a sample qvw.

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

Hi Tom,

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

Regards,

Kaushik Solanki

tom2qlik
New Contributor III

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

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

Capture.PNG

Check this. The axis is still the same.

Regards,

Kaushik Solanki

antoniotiman
Honored Contributor III

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

Hi Tom,

this is behavior QV 11.20.

OK in 12.10.

Regards,

Antonio

tom2qlik
New Contributor III

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

Not for me

I'm using the same qvw as you.

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

What version you are using?

Regards,

Kaushik Solanki

antoniotiman
Honored Contributor III

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

QV 12.10

QV 11.20

Community Browser