Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
coka90
New Contributor

How to limit first n rows in two columns(dimension and expression)?

How to limit first n rows in two columns(dimension and expression)?

I have this qurey, but with them I just limit expression, not dimension?

Top5:
First 5 LOAD BI,
Avg(OCENA) as Prosek
Resident Ispit Group By BI ;

Can someone help me? Tnx

1 Reply
Vegar
Valued Contributor

Re: How to limit first n rows in two columns(dimension and expression)?

Try the following

Top5:
First 5 LOAD
*
Ordet by Prosek;
Load
BI,
Avg(OCENA) as Prosek
Resident Ispit Group By BI ;
Community Browser