Article top list

[Nilssonqlik]

I have a report in QlikView showing the average price per article bought each month. How can I make a selection so that the report only shows the 100 articles with the highest aggregated amount during a specific period?

[Maria_Halley · Accepted solution]

@Nilssonqlik 

This sounds more like a Application Development question so I will move this to that board

[rajpreeths]

Go to chart properties -> Dimesion Limits -> 

Pick a required dimension (in your case it might be a month )

->

Check the box 'Restrict which values are displayed using first expression' and then 'show only 'drop down choose largest and put a value 100 in the box 

-> if you don't want to view articles other than top 100 uncheck 'Show others option'

[Nilssonqlik]

Hi, thank you for this, yet I need a bit more as to specifics as I'm using the Swedish version and the with the Swedish words. If there's any chance you could grab some screen shots to help me, I'd apreciate it. For example, I'm thinking that First expression is Första sträng... so any more details would realy help. 

Thanks, Johan