Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Dimension limit on line chart

Hi,

I have a line chart with two dimensions and one expression. I have enabled dimension limit on 2nd dimension to show only largest 10 values. But still I see more than 10 dimensions in the line chart.

 

Attached is the sample app.

From what I understand, since my first dimension is month-year, I think the chart is showing top 10 from each month. That is why there are more than 10 values in the chart because the top 10 for each month would be different.

Is there a way to how the overall top 10 in the chart only?

 

Thanks in advance!

Yash

 

 

1 Reply
Highlighted

Re: Dimension limit on line chart

I guess you are seeing top 10 for each MonthYear dimension... so for two different months you can have different top 10s. Do you want to only see the top 10 across all the months? Try this expression without any dimension limits

Dual(
Num(Sum({<DISCOUNT_CD = {"=Rank(Sum(DISCOUNT_AMT)) < 11"}>}[DISCOUNT_AMT]),'$#,##0.00') & Chr(10)& Num(Sum({<DISCOUNT_CD = {"=Rank(Sum(DISCOUNT_AMT)) < 11"}>}[DISCOUNT_AMT])/Sum({<DISCOUNT_CD = {"=Rank(Sum(DISCOUNT_AMT)) < 11"}>} TOTAL<MonthYear> [DISCOUNT_AMT]),'0%'),
Sum({<DISCOUNT_CD = {"=Rank(Sum(DISCOUNT_AMT)) < 11"}>}[DISCOUNT_AMT])
)

to get this

image.png