Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if i want give same rank for two records is it poosible?
Please post some sample data and a description of how the result should be presented.
Hi Manoj,
Two ranking functions exists. "HRank" is particularly for Pivot Tables, while "Rank" suits for other charts.
So depending on the kind of chart need to use the specific rank function.
rank([ total ] expression [ , mode [, format ] ])
Ranking is returned as dual value, "mode" governs the integer representation while "format" governs the text representation. So 2 records with same ranking can be represented accordingly. Please refer the Reference manual for detailed help on this in "Chart Ranking Functions"
Thanks,
Sri
Hi Manoj,
Try Rank() like below
=Rank(Sum(Sales) for example add Dimension as EmpID, then you will get the Rank by sales done by each employee.
Refer Qlikview help file for more details.
Regards,
Jagan.