topic Re: How to solve the issue in QlikView

How to solve the issue

Tue, 04 Feb 2014 13:36:28 GMT

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.

Re: How to solve the issue

hic — Tue, 04 Feb 2014 13:52:06 GMT

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

HIC

Re: How to solve the issue

Tue, 04 Feb 2014 13:53:56 GMT

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

Re: How to solve the issue

hic — Tue, 04 Feb 2014 14:03:08 GMT

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

Re: How to solve the issue

Tue, 04 Feb 2014 14:06:08 GMT

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 .

Re: How to solve the issue

hic — Tue, 04 Feb 2014 14:16:20 GMT

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

Re: How to solve the issue

Tue, 04 Feb 2014 14:29:53 GMT

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

Re: How to solve the issue

Anonymous — Tue, 04 Feb 2014 14:34:27 GMT

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".

Re: How to solve the issue

Tue, 04 Feb 2014 14:37:24 GMT

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?

Re: How to solve the issue

Anonymous — Tue, 04 Feb 2014 14:40:24 GMT

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".

Re: How to solve the issue

Tue, 04 Feb 2014 14:44:00 GMT

Thanks but the values are shoing incorrect do I need to cahnge anything here? please let me know.

Re: How to solve the issue

Anonymous — Tue, 04 Feb 2014 14:50:28 GMT

Nobody here can answer this question. It is about your data and your requirements. You need help onsite.

My last comment here - it doesn't make any difference, at least in your example, which expression to use - Count(ID) or Count(TOPID) or Count(Value). The result will be exactly the same...

Re: How to solve the issue

Tue, 04 Feb 2014 14:52:26 GMT

Thanks!