Discussion Board for collaboration on QlikView Layout & Visualizations.
I am new to Qlikview.. My purpose here is to get top 5 rows in a straight table..
Actually if we do like this in edit script we'll get a new field right?
SELECT TOP 5 * FROM TABLENAME;
but thats not the thing I want.
For example the following is a straight table..
So here I want Details only upto Harish...for that what expression we have to use??
Or what we have to do??
Thank you all...Please Help and do reply
Soon reply is appreciated..
Go to Solution.
On the Presentation tab of the properties screen set Max Number (1-100) to 5. Then only 5 rows will be shown.
Oh wow thank you so much Gysbert...!!
if u use qv11 then
dimension limits tab
check the check box and give ur required values
if u give 5 then it display upto top 5 values
oh yeah Both of your answers are working ..Thank you..!!