topic Re: Count missmatch in QlikView

Count missmatch

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

Hi All,

Please find the attachment of Qlikview file ..

I have two tables ..... Table A and Table B ..

My actaul requirement are implemented in Table A .. in which i will be showing the average of 3 years

( Average of last two years including current year) and till date month counts for current year..

Now in Table A iam getting wrong counts for the month of Mar 2018 for Severity 2 and 3 ...( Actual count should be 400 for severity 3 , and 70 for severity 2 ..)

and the correct counts for Mar 2018 are shown in the Table B ..

Please do help me in geting this correct .. there is missmatch in the Mar 2018 month..other than this

Table A is showing proper data for all including the Average..

Thanks in Advance

Re: Count missmatch

Chanty4u — Wed, 11 Apr 2018 12:17:09 GMT

how many dimensions do you have?

remove one by one dimension and check for the result.

Re: Count missmatch

sunny_talwar — Wed, 11 Apr 2018 12:23:53 GMT

Try this

Pick(Dim,

count({<[When Found]={'Production'},Created={">=$(=Yearstart(Max(LoadDate)))<=$(=TimeStamp(Max(LoadDate), 'DD-MM-YYYY hh.mm.ss'))"}>}Created),

round(Count({<[When Found]={'Production'},Created={">=$(=Yearstart(Max(LoadDate),-2))<=$(=YearEnd(Today(),-2))"}>}Created)/12,0.01),

round(Count({<[When Found]={'Production'},Created={">=$(=Yearstart(Max(LoadDate),-1))<=$(=YearEnd(Today(),-1))"}>}Created)/12,0.01),

count({<[When Found]={'Production'},Created={">=$(=Yearstart(Max(LoadDate)))<= $(=Max(LoadDate))"}>}Created)/$(eAvgyear))

Re: Count missmatch

vvira1316 — Wed, 11 Apr 2018 12:24:52 GMT

If it is showing right data for other months then are you sure there is no data issue for the month of March. I feel that there may be some data discrepancy. Please check. I think if there was any calculation error then there should have been problem with other information as well.

Re: Count missmatch

smilingjohn — Wed, 11 Apr 2018 12:48:23 GMT

Hi sunny,

Thanks legend you always rock .....

can you please tell me what makes the differnec and this is giving the correct results ..?

it will be more helpfull for me if you can please explain me ..

tahnks

Re: Count missmatch

sunny_talwar — Wed, 11 Apr 2018 12:50:56 GMT

Max(LoadDate) was giving a number format back, but Created was a timestamp in DD-MM-YYYY hh.mm.ss format.... it is annoying, but set analysis is very format sensitive... all you needed was to Wrap Max(LoadDate) with the correct formatting

Re: Count missmatch

smilingjohn — Wed, 11 Apr 2018 13:01:53 GMT

Thanks a lot sunny ...