topic Line Chart issue in QlikView

Line Chart issue

amayuresh — Fri, 13 May 2016 12:18:30 GMT

Hi Team,

I am having Trend Line chart showing Month on axis and Number on Y-axis with below details,

Dimensions:

Month, Calculated dimension

Calculated dimension in uses RANK and AGGR function

This is used to filter out top X Supplier names from table on the basis of variance of last year and Current year Spend

Expression: Current Year Spend

Sort Calculated Dimension on variance by Descending order

This is taking time to refresh the chart, is there any alternative to show the same result.

Like using dimension limit, which works faster than this.

sunny_talwar — Fri, 13 May 2016 12:19:55 GMT

May be, but just by description itself it would be hard to suggest anything. Is it possible to share a sample?

Chanty4u — Fri, 13 May 2016 12:20:59 GMT

u can create a flags for years in backend and use those flags in chart.

Fri, 13 May 2016 12:27:38 GMT

Calculated dimension with Aggr and Rank takes time based on the volume of the records.

What is the volume of records you have? Else use the order by and recno() function in script to calculate the ranking,

amayuresh — Fri, 13 May 2016 12:28:11 GMT

Sure. Let me post sample document.

sunny_talwar — Fri, 13 May 2016 12:42:39 GMT

Thank you. that would be very helpful.

Best,

Sunny