How to solve the issue

[#1]

Hi,

Can anyone let me know please how can I calculate Issues by Value

As I tried but I am not sure whether i picked the right one or not

Please find attached.

Thanks.

[hic]

Is it not just a matter of sorting the table you have created?

HIC

[#3]

Thanks and sorry I am not clear. You mean that what I did is correct?

[hic]

Depends on what you mean by "Issues by Value". If it is the same as what I posted in my previous answer, then, yes, it is correct. It just needed to be sorted by the Count(Value).

HIC

[#5]

Thanks and I mean that. But what is the problem is it is showing values incorrect when I compared with values which are in acccess database. Please can you let me know do i need to change anything in this .

[hic]

I don't know what your DB shows or why. But it seems to me that your data is "dirty":

You want to display Count(Value), but as you can see the field "Value" is sometimes blank, sometimes has a number and sometimes has the string "confirmed". QlikView counts all. Is that what you want - or do you just want to count the 1381 confirmed ones?

HIC

[#7]

Thanks and I need to count all values including string but  without blanks. Is it possible to show that?

[Anonymous]

Besides, the "Issue data" is not clean either.  There are identical values with different capitalization, for example "Monthly Contribution Arrears", ''Monthly contribution arrears", "monthly contribution arrears".

[#9]

Yes you are right I set that with script. But my problem is I am not able to get the exact values. will it not be possible if I don't have data is not clean in database?

Actually I got confused whether do I need to tale Count(ID) or Count(TOPID) or Count(Value).

Could you please let me know this whihc expression I need to consider?

[Anonymous]

With the "Issue" it is possible.  Use

capitalize(Issue) as Issue

in the script.  So, in the example above they all will be "Monthly Contribution Arrears".