Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
amayuresh
Creator III
Creator III

Line Chart issue

 

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.

 

5 Replies
sunny_talwar

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

Chanty4u
MVP
MVP

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

Not applicable

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
Creator III
Creator III
Author

Sure. Let me post sample document.

sunny_talwar

Thank you. that would be very helpful.

Best,

Sunny