topic Re: Count if Value only once in QlikView

Count if Value only once

Nagaraju_KCS — Sat, 16 Nov 2024 00:22:17 GMT

Hi Community,

facing issue on count value is one.

I have calculated but showing wrong result.

exp: Count({<sn = {"=Count({<Group={'FAIL'}>}sn) = 1"}>}sn) - this expression value showing for one particular case 41, but when i click on 41 row, it changing the value to 67. but my value should be 67

Please find the attachment.

Please correct me what was the wrong

Thanks in Advance!

Re: Count if Value only once

tresB — Tue, 07 Jul 2020 05:30:12 GMT

For that, (since you are using the desc dimension in the chart) you have to modify your expression a bit, like:

Count({<sn = {"=Aggr(Count({<Group={'FAIL'}>}sn) = 1, desc,sn)"}>}sn)

Re: Count if Value only once

Nagaraju_KCS — Tue, 07 Jul 2020 05:54:42 GMT

I got the solution, anyhow thank you so much 🙂

Re: Count if Value only once

Nagaraju_KCS — Tue, 07 Jul 2020 07:50:10 GMT

Hi Tresesco,

This is not working for >1.

Count({<sn = {"=Aggr(Count({<Group={'FAIL'}>}sn) > 1, desc,sn)"}>}sn)

Could you please help me!

Re: Count if Value only once

felcar2013 — Tue, 07 Jul 2020 09:48:53 GMT

hi,

try this

Count({<sn = {"=if(Count({$<Group={'FAIL'}>}sn)>1,Count({$<Group={'FAIL'}>}sn))"}>}sn)

Re: Count if Value only once

tresB — Tue, 07 Jul 2020 10:15:51 GMT

Can you explain with an example - the expected output and the result you are getting?

Re: Count if Value only once

Nagaraju_KCS — Tue, 07 Jul 2020 11:06:01 GMT

Thanks for reply!

I have tried this expressions, not giving correct result.

as er below scenario, total count is 71, one count is 67 remaining is greater than one count. that should be 4.

one count is working fine, but greater than one count showing wrong result.

when i click specific records - both values are showing correct.

while validating whole data not presenting all the records.

Please find the attachment for sample

Re: Count if Value only once

tresB — Tue, 07 Jul 2020 10:54:58 GMT

Change your expression to:

Count(if(Aggr(NODISTINCT Count(if(Group='FAIL',sn)), desc,sn)>1, sn))

Re: Count if Value only once

Nagaraju_KCS — Tue, 07 Jul 2020 11:05:26 GMT

Perfect! Very helpful Tresesco 🙂