Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i want top 10 countries data based on sales .
But should not use dimension limits.
should not use Aggregation rank function.
is there any option to solve this
if it is so which will give better performance rank with aggregation or given answer let me know
regards
Mahesh
Create a Straight Chart
Dimension :
Country
Expression
SUM(Sales)
Sort Data for Country by Expression = SUM(Sales)
Descending Order
Now under Dimension Limit
Tick restrict which values.....
Show Only
Largest and 10 values....
Use RANK with AGGR
There is a video on youtube that shows how to do this
Go to youtube and type Qlikview RANK
I should not use dimension limits or agrregation and rank
alternative 3rd appraoch
Hi
I think you should do that at script level with group by & Order by Desc
& then create a flag for those value.
Use that flag in the expression.
Regards,
Nirav bhimani
Hi,
Hope it helps you.
T:
LOAD Country,
Sales,
RowNo()
FROM
C:\Users\Acer\Desktop\Book1.xlsx
(ooxml, embedded labels, table is Sheet1);
T1:
LOAD Country,RowNo(),
Sum(Sales) as SalesAmt
Resident T
Group By Country
;
MainTable:
First 10
LOAD Country,SalesAmt Resident T1 Order By SalesAmt desc;
DROP Table T,T1;
Thanks,
Jagan