Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Regarding the Display of Serial No

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

Tags (1)
5 Replies
vikasmahajan
Honored Contributor III

Re: Regarding the Display of Serial No

Nikita You can use distinct clause with AGGR function.

Not applicable

Re: Regarding the Display of Serial No

hi vikas,

I tried but its not working.

vikasmahajan
Honored Contributor III

Re: Regarding the Display of Serial No

Please post sample application so that I can help you.

Vikas

sivarajs
Valued Contributor II

Re: Regarding the Display of Serial No

try using rowno() or else

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

Not applicable

Re: Regarding the Display of Serial No

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.

Community Browser