Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

markgraham123
Contributor II

Compressing Line chart X axis dimensions

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

1.jpg

Tags (2)
1 Solution

Accepted Solutions

Re: Compressing Line chart X axis dimensions

Hi,

try like:

QlikCommunity_Thread_168872_Pic3.JPG

QlikCommunity_Thread_168872_Pic4.JPG

hope this helps

regards

Marco

11 Replies
markgraham123
Contributor II

Re: Compressing Line chart X axis dimensions

Without using scroll bar

Not applicable

Re: Compressing Line chart X axis dimensions

Could you post an example application?

markgraham123
Contributor II

Re: Compressing Line chart X axis dimensions

HI,

Here is the application.

Re: Compressing Line chart X axis dimensions

Hi,

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

QlikCommunity_Thread_168872_Pic1.JPG

QlikCommunity_Thread_168872_Pic2.JPG

hope this helps

regards

Marco

markgraham123
Contributor II

Re: Compressing Line chart X axis dimensions

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?

markgraham123
Contributor II

Re: Compressing Line chart X axis dimensions

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?

2.PNG

Re: Compressing Line chart X axis dimensions

Hi,

try like:

QlikCommunity_Thread_168872_Pic3.JPG

QlikCommunity_Thread_168872_Pic4.JPG

hope this helps

regards

Marco

markgraham123
Contributor II

Re: Compressing Line chart X axis dimensions

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.1.jpg

mov
Esteemed Contributor III

Re: Compressing Line chart X axis dimensions

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

Community Browser