Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
prathipsrinivas
Contributor

Display Top N dimensions using the Expression in Straight Table

Hi Qlikers,

I have a requirement where I need to show only top N Clients according  to varience (Actual - Budget) in the Straight Table.

I have tried using Dimension limits but it's not working as expected.

Could you please help me implement using any logic?

Labels (1)
1 Reply
sivakumar1994
New Contributor III

Re: Display Top N dimensions using the Expression in Straight Table

Trying sorting by mean value of (Actual - Budget) in Descending order, then apply dimensional limit for first 10 records only.