topic Re: How to split y axis? in QlikView

How to split y axis?

Mon, 20 Oct 2014 08:11:55 GMT

Hi there,

i found out, that there's a function called "Split Axis".

But it seemed it works only if you have 2 formulas and set the positions to left or right.
Now i have only one formula with values from 500 to 220.000 and i want to hide the area between 140.000 and 180.000 i.e.

Is there a possibility to solve this problem?

Thanks and regards from germany,

Sabrina

Re: How to split y axis?

ogster1974 — Mon, 20 Oct 2014 08:26:16 GMT

One way you can do this is by removing the data between 140.000 and 180.00 from your data set using set analysis.

Something like:

SUM({<Value={"<=180000 >=140000"}>} Value) to remove the data you don't want to see in your chart.

Hope this helps.

Regards

Andy

Re: How to split y axis?

Mon, 20 Oct 2014 08:31:09 GMT

Thank you!

And what about, if i have more than one area to hide?

i.e. hide 20.000 to 40.000 and 80.000 to 100.000 and 160.000 to 200.000 ?

Thanks and best regards

Sabrina

Re: How to split y axis?

ogster1974 — Mon, 20 Oct 2014 08:49:20 GMT

Build your exclusions up something like

SUM({<Value={"<=20000 >=40000"}>},SUM({<Value={"<=18000 >=140000">} Value)) to build up your exclusions.

Another way to consider if you can is to add an exclusion flag to your data to remove the values from your dataset at or before load or using set analysis on the data once loaded.

SUM({<_ExclusionFlag={"=1"}>} Value)

Please mark replies as appropriate.

Regards

Andy

Re: How to split y axis?

Mon, 20 Oct 2014 09:02:34 GMT

Hi Andy,

i don't have to build summarys because these are allready in the table and i have only reflect this in qlikview.

Thanks and regards,

Sabrina

Re: How to split y axis?

ogster1974 — Mon, 20 Oct 2014 09:08:09 GMT

Then building your exclusions of data using set analysis as you summarise the data is the way to go.

SUM(3rd Exclusion set, SUM(2nd Exclusion set, SUM(1st Exclusion set , Value)))