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.

[#2]

could you tell me how to use preceding load and what it means?

[MK_QSL]

Preceding Load : You can get information from searching in QlikView community.

I can see that you have RIGHT joined two different tables based on FIELDS Queue and Res...

Why don't you try to Load these both tables and rename one of the field .. i.e. Res as Queue...

Now do right Join same as your SQL or ACCESS Query....

This will also give you same result....

At this stage, you have to match your ACCESS and QlikView, otherwise no chance of getting the same result..

I can't help much more than this... Hope you understand...

[#4]

will try Thanks for your help regarding this all.

[#5]

I tried but nothing showing as still same error. This becomes a night mare to me now

[MK_QSL]

Can you load your ACCESS results in Excel file here?

Need Full FILE to understand what is the difference coming !!

[#7]

Please find attached.

[MK_QSL]

how you get status of clients?  Like below..

New Client Logged

Contact

Advice

Customer Service Allocation

Customer Service Paperwork

Draft Allocation

Drafting

Draft to Debtor

Creditor Meeting

Case on Hold

Case Dead

Declined

[#9]

Sorry could you alloborate what you mean?please

[MK_QSL]

From the file you have uploaded, I can see only ClientID and When, but where is the link of ClientID and Specific Stage of this client... i.e. New Client, Case Hold, Declined... How you get this information?

If there any criteria you are using?

[#11]

I got you . Please could you have look on my attached pngs and there is all links for the tables and queries whihc are used in this report.