topic Re: Cummulative logic in a chat in QlikView

Cummulative logic in a chat

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team

I have two requirement as per below scenario .

1. I want to find whether the CR field is Null or Not

2. I want to count the CR filed counts as per below logic

Logic

If CRs field NOT NULL, then increment count by 1
Note :Users expect this cumulative count as the count of total CRs

I am Sharing the sample data and sample QV report .

Please help me on this

Thanks in advance !

Regards

Mahesh.

Re: Cummulative logic in a chat

sunny_talwar — Tue, 17 Jan 2017 13:00:40 GMT

What is the expected output (in numeric terms)?

Re: Cummulative logic in a chat

Anonymous — Tue, 17 Jan 2017 13:06:49 GMT

Hi Sunny

Yes the expected output will be in numeric .

for example if we CR like 34;56;78;92 we coinsder it as single value

Re: Cummulative logic in a chat

sunny_talwar — Tue, 17 Jan 2017 13:21:51 GMT

Right so what is the values you are expecting to see then?

Re: Cummulative logic in a chat

Anonymous — Tue, 17 Jan 2017 13:32:21 GMT

Sunny

if i use count(CR) in the expression i was able to see the count of CR for that particular Month.

But the problem occurs when i what to see in cumulative form .

If I select the multiple CRS here i want to display the 1 record+2 +3 like this

please find the attached screen shot if i am not clear

Re: Cummulative logic in a chat

sunny_talwar — Tue, 17 Jan 2017 13:39:47 GMT

Mahesh -

I am still not sure what you want buddy. I really want to help but don't know what are the numbers you are looking to get here?

For Dec, we have 1, Jan we have 2.... is this not right? what is that you want instead?

Re: Cummulative logic in a chat

sunny_talwar — Tue, 17 Jan 2017 13:40:21 GMT

The screenshot clarifies what you want, thanks for that

Re: Cummulative logic in a chat

sunny_talwar — Tue, 17 Jan 2017 13:42:20 GMT

This?

Re: Cummulative logic in a chat

Anonymous — Tue, 17 Jan 2017 13:53:09 GMT

Thanks Sunny For the Clarifying my Question it help me a lot .

For the sample data which i had currently it is getting the exact output as per my requirement . Tomorrow i will check the original data which i had i will update you if i required anything .

One more thing in the above requirement. I want to handle the null also where the data blank in CRS is i want to display it as NULL or 0 .

Please advice me on this also

Re: Cummulative logic in a chat

sunny_talwar — Tue, 17 Jan 2017 14:07:27 GMT

Isn't it already doing that? CRS is null for oct and we don't see oct in the bar chart, right?

Re: Cummulative logic in a chat

Anonymous — Tue, 17 Jan 2017 14:09:52 GMT

Not in chart sunny , i want it to display in list box

in the List i was able to see Blank spaces in the original data i had, i cant share you that .

please advice me how to handle NULL in such cases and Display it as ZERO or NULL

Re: Cummulative logic in a chat

sunny_talwar — Tue, 17 Jan 2017 14:12:08 GMT

May be handle it in the script:

LOAD Year,

Month,

Num,

If(Len(Trim(CRS)) = 0, 'NULL', CRS) as CRS

FROM

(ooxml, embedded labels, table is Sheet1);

Re: Cummulative logic in a chat

Anonymous — Tue, 17 Jan 2017 14:15:43 GMT

Thank you Sunny for spending your time on my issue .

Re: Cummulative logic in a chat

sunny_talwar — Tue, 17 Jan 2017 14:16:53 GMT

No problem at all

I am glad I was able to help

Re: Cummulative logic in a chat

Anonymous — Thu, 19 Jan 2017 10:41:08 GMT

Hi Sunny

when I am calculating the% in line. and I am using Full Accumulation option

then it shows wrong for example if Dec2016 I am having 100 % and Jan 2017 is having 100 % it shows as 200% in the output

My expected output was I am having IR count as 2 for JAN and when I use full accumulation pervious month will be added I.e 1 total IR count was 3 .

For CR also same Logic so count Should 3 .

Then CR/IR = 3/3 = 100%

Please help me on this

I am sharing the sample QV and data

Re: Cummulative logic in a chat

sunny_talwar — Thu, 19 Jan 2017 10:46:06 GMT

What is CR and is IR brother? I am not sure I understand what you are looking for. Can you make sure that your sample qvw is inline with what you are saying here

Re: Cummulative logic in a chat

Anonymous — Thu, 19 Jan 2017 11:11:28 GMT

Hi Sunny

I am expecting 100 % , Here is sample Qvw I had load data in Inline

Please have a look

Thanks

Re: Cummulative logic in a chat

sunny_talwar — Thu, 19 Jan 2017 12:14:38 GMT

Then don't accumulate your last expression?