topic Re: Compressing Line chart X axis dimensions in QlikView

Compressing Line chart X axis dimensions

markgraham123 — Wed, 17 Jun 2015 21:20:35 GMT

Hi Everyone,

I have around 1,80,000 Products on X-axis and its sales on Y-axis.

I wanna compress the dimensions of X-axis and want to see a trend using Line chart in single screen.

I'm trying to get an output like the attached screenshot. Someone help me

Re: Compressing Line chart X axis dimensions

markgraham123 — Wed, 17 Jun 2015 21:23:57 GMT

Without using scroll bar

Re: Compressing Line chart X axis dimensions

Wed, 17 Jun 2015 21:24:04 GMT

Could you post an example application?

Re: Compressing Line chart X axis dimensions

markgraham123 — Wed, 17 Jun 2015 21:34:45 GMT

HI,

Here is the application.

Re: Compressing Line chart X axis dimensions

MarcoWedel — Wed, 17 Jun 2015 21:50:22 GMT

Hi,

one solution could be to switch the dimension axis to "continuous" mode:

hope this helps

regards

Marco

Re: Compressing Line chart X axis dimensions

markgraham123 — Wed, 17 Jun 2015 21:56:17 GMT

Hi Marco,

Excellent.

It worked. But we have an issue here. As you observe its showing 10000000 as the product here.

How to eliminate it?

Re: Compressing Line chart X axis dimensions

markgraham123 — Wed, 17 Jun 2015 22:00:20 GMT

Hi Marco,

But why am i getting 120 % on y-axis and 10000000 in X-axis when those values are not available.

Can we eliminate those values?

Re: Compressing Line chart X axis dimensions

MarcoWedel — Wed, 17 Jun 2015 22:46:49 GMT

Hi,

try like:

hope this helps

regards

Marco

Re: Compressing Line chart X axis dimensions

markgraham123 — Thu, 18 Jun 2015 00:15:10 GMT

Hi Marco,

Its working independently.

But when i try with the original QVW which has loads and loads of data in it, it hangs and gives me this output.

Im confused.

Re: Compressing Line chart X axis dimensions

Anonymous — Thu, 18 Jun 2015 01:01:30 GMT

Mark,

First, line chart is not the best choice here. Line charts are first of all to show some process in time, that is the X-axis is for a time dimension (day, month, year, millisecond...). What information the line chart shows when the Product is the dimension?

Second, if you have millions of dimension values on chart, it will be slow.

I can't guess what exactly you trying to do and why, but you need to re-consider the way you present the data. Anyway, look at this bar chart. Here the dimension is using class() function, and expression is avg(). Performance is fine with your sample data. App is attached.

Regards,

Michael

Re: Compressing Line chart X axis dimensions

markgraham123 — Thu, 18 Jun 2015 01:25:10 GMT

Marco,

Got it.

Thank you verymuch for your time and expertise.

Re: Compressing Line chart X axis dimensions

markgraham123 — Thu, 18 Jun 2015 01:25:41 GMT

Michael,

Thank you very much.