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]

Thanks. please find attached.

[MK_QSL]

Unable to open your file... it says failed to open document.

[#4]

Could you try now please.

[MK_QSL]

Dear Amelia,

The total is coming actually ok.... looks like what you have mentioned correct is coming for Queue where What is NULL.

Let me know if I am wrong...

[MK_QSL]

Try below code to check what I have replied above...

Straight Table

Dimension : Queue

Expression: as below

COUNT({<What = {' '}>}DISTINCT ClientID)

[#7]

Thanks.I tried your code above and reloaded the file again and it is showing like which are in attached.  Please help me as tnere is NULL in What.

[MK_QSL]

So what you finally want?

Your Data without NULL?

if yes, replace the expression as below...

COUNT({<What -= {' '}>}DISTINCT ClientID) & '    '& NUM(COUNT({<What -= {' '}>}DISTINCT ClientID)/COUNT(TOTAL{<What -= {' '}>}DISTINCT ClientID),'#,##0.00%')

[#9]

Thanks.I tried with the above and when Iused this it is showing different figures from database which are in attached.

And also it is showing error(red underline) in expression

Outcomespng are values from access database

OucomesFigures are values from qvw

Please help as we are near to destination I suppose.

[MK_QSL]

as per your access database

Queue = Advice

What = Advice

Data Showing NULL or 0....

But as per your .QVW file,,, it should be 981....

How's that possible?

Hope you are not doing anything wrong with Access....

[#11]

Thanks. The access database is fine and up to date. That's how I would need to build the report based on above requirements which you mentioned. As they have report in access database. But the user is looking exact the same in Qlikview. Please could help me as I am not getting how to ste this completely.