Regarding the Display of Serial No - Qlik Community

Report Inappropriate Content · ‎2013-05-08

Hi Friends,

I have straight table for Top 5 Dealers in which i have Problem in displaying the order of Sl.No for some selection it is showing 2 numbers like 3-4 or 5-6 instead of displaying one at a time in order . So pls Help me out in resolving this issue where exactly the problm may be. Pls see the Attached Screenshot. The Expreesion I am using is

IF(aggr(rank((count({<COMMON_MONTH={$(#vMaxMonth)},[Complaint Source]={'TKM','Dealer, TKM','TKM, TMC','Dealer, TKM, TMC'},[Complaint Related To]={'Sales'}>}[Complaint Number])

/

SUM(Sales_Volume)) * 100),Dealer)<=5,

aggr(rank((count({<COMMON_MONTH={$(#vMaxMonth)},[Complaint Source]={'TKM','Dealer, TKM','TKM, TMC','Dealer, TKM, TMC'},[Complaint Related To]={'Sales'}>}[Complaint Number])

/

SUM(Sales_Volume)) * 100),Dealer))

Thanks in Advance,

NikithaJain

vikasmahajan · ‎2013-05-08

Nikita You can use distinct clause with AGGR function.

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2013-05-08

hi vikas,

I tried but its not working.

vikasmahajan · ‎2013-05-08

Please post sample application so that I can help you.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

sivarajs · ‎2013-05-08

try using rowno() or else

SubField(SINo,'-') as SINo in script

Report Inappropriate Content · ‎2013-05-08

thanku for the reply Sivaraj

I tried using rowno() but the values will not cme properly so i tried using the above expression with rank function involved.

To use Subfield 'sl.no' field does not exist in the script.So I am directly using the expression in the Straight table. Is der any other way,pls suggest.