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]

But something is wrong.... if you create a straight table

with dimensions....

Queue and What

and Expression

Count (Distinct ClientID) it is showing completely different figures.

Try in your system...

Are you sure you have loaded data in the script correctly?

I may be wrong ....!!!

[#3]

Yes I am sure the data in the script is loaded correct. Please help me is there any way to set this completely?

[#4]

Hi Manish.

I will wait for your solution please help as i need to set this completely. Any solution please

[MK_QSL]

Can you write a script or something which you are using in Access Database....?

[MK_QSL]

I can see from your Access answer that each ClientID is coming only once for Queue...

i.e. if any client ID counted for Advice it will not appear again for any field.

Correct me if I am wrong.

[#7]

Hi,

Thanks I will try to find this and will send you. Because access script was created by another person in my organisation. This is now very important for me to complete.

Please help me if I found access script and send you.

I have to set this completely very urgent please. I have still hope that I get answer from you.

[#8]

Hi Manish,

Please can you find the below and attached ones and help me please as I added almost I can.

SQL Script:

SELECT CInt(Nz([Sort],99)) AS Sort1, qryOutcomesRpt.Res, qryOutcomesRpt.Total, qryOutcomesRpt.[New Client Logged], [New Client Logged]/[total] AS [Logged%], qryOutcomesRpt.Contact, [contact]/[total] AS [Contact%], qryOutcomesRpt.Advice, [advice]/[total] AS [Advice%], qryOutcomesRpt.[Customer Service Allocation], [Customer Service Allocation]/[total] AS [CSA%], qryOutcomesRpt.[Customer Service Paperwork], [Customer Service Paperwork]/[total] AS [cs%], qryOutcomesRpt.[Draft Allocation], [Draft Allocation]/[total] AS [da%], qryOutcomesRpt.Drafting, [drafting]/[total] AS [Drafting%], qryOutcomesRpt.[Draft to Debtor], [Draft to Debtor]/[total] AS [dd%], qryOutcomesRpt.[Creditor Meeting], [Creditor Meeting]/[total] AS [cm%], qryOutcomesRpt.[Case on Hold], [Case on Hold]/[total] AS [Hold%], qryOutcomesRpt.[Case Dead], [Case Dead]/[total] AS [Dead%], qryOutcomesRpt.Declined, [Declined]/[Total] AS [Declined%]

FROM tblQueue RIGHT JOIN qryOutcomesRpt ON tblQueue.Queue = qryOutcomesRpt.Res

ORDER BY CInt(Nz([Sort],99));

[MK_QSL]

Have you used the same Query in QlikView Script?

[#10]

Hi Manish,

Yes I tried but it is showing undefined function Nz

[MK_QSL]

If you use something different in QlikView Script, you will definitely having different result.

Try to use Preceding Load in QlikView Script....