Discussion Board for collaboration related to QlikView App Development.
I have to sort my table on the basis of the expressions. And after sorting i have to show only the top 20 values of the expression along with the Dimensions.
Please have a llok on the attached file.
Hope it helps.
You can specify this in the Dimension Limits tab of the chart properties.
A sample application is attached.
Hey in this application there is no sorting at all on the basis of expression
I used below expression
IF(Domain ='Sales',1,IF(Domain ='COGS',2,IF(Domain ='Marketing',3,IF(Domain
hey in your report Top 5 expresisons are sorted as 400,200,300,800,500.But i want that they should be sorted as 800,500,400,300,200.
Then uncheck expression from Sorting.
Use Dimension limits.
For all dimensions dont ckeck any option.
here is the attached sample data application. Pleasetell how to sort
Please find attached doc.
here the partial sum which it's showing is of all the rows not of the top 5