How to get Breakdowns of Total

[#1]

Hi,

I have straight table in attached qvw. I need to show the break down of each Queue. I have Total Queue already created but I would need the Breakdowns which was showing in attached png.

could anyone help me by looking into attached please.

Thanks.

[MK_QSL]

where is the attachment?

[#3]

I have attached in which SQL Script is there and the time is Jan 30, 2014 5:33 AM

[MK_QSL]

In your script...History Tab...

Try below...

TblHistory:

  LOAD *,

  IF(ClientID = PREVIOUS (ClientID) AND Queue <> Previous(Queue) , When1-PREVIOUS(When1),' ') as CycleTime

  RESIDENT

  TblHistoryTemp1

    Order by ClientID, Queue;

[#5]

Thanks . Still showing the values different from access database. Please help me do I need to change anything like this in script?

[MK_QSL]

Also looks something wrong in your LINK TABLE TABLE....

Try Something below..

Add a Field in your

LinkTable:

  LOAD DISTINCT

  ClientID&'-'&DateLogged as %Key1,

  ClientID&'-'&DateLogged as %TEMP_Key1,

  ClientID,

  DateLogged,

  Queue,

  Flag,

  ' ' as [From-To],

  ' ' as CycleTime,' ' as What,

  NomineeFeeAgreed,

  'LoggedDate' as DateType,' ' as Who

  // Year,Month,' ' AS [Target_ Nominee Fees]

  RESIDENT TblClient;

  CONCATENATE

  LOAD DISTINCT

  ClientID&'-'&When as %Key1,

  ClientID,

  When as DateLogged,

  Queue,

  Flag,

  [From-To],

  CycleTime,

  What,

  ' ' as NomineeFeeAgreed,

  'When' as DateType,

  Who

  // Year(When) AS Year,Text(Month(When)) AS Month ,' ' AS [Target_ Nominee Fees]

  RESIDENT TblHistory

  Where NOT Exists (%TEMP_Key1,ClientID&'-'&When);

Drop Field %TEMP_Key1;

================

Why you have again CONCATENATE TblClient Table?

Try These changes and let me know..

[#7]

Thanks and I tried this still showing same difference. Do I need to change any other?please help me

[#8]

Hi Manish,

I was wondering are you working on the script to change?Please let me know.

[MK_QSL]

Dear Amelia,

I have checked your whole script and suggested necessary changes.

Now it's beyond my limitation.

Sorry can't help further.

I have to work whole project on my own then only can found the error.

Hope you understand.

[#10]

ok Thanks Manish and sorry if I bothered you and once again thanks for all your help up to now regarding this