topic Re: Set analysis not working in QlikView

Set analysis not working

deepakkrish — Sat, 16 Nov 2024 01:51:08 GMT

Hi All,

My dimension filed is Market and I have to show the count of account when its meets below condition. But i dont know why its not giving correct value ..

please suggest me the solution.

Dim : Market

Exp : =Count({<Str_Account__c={1},Flag={0},Level1={'Retail'},

TeamMemberRole={"=$(= Count(TeamMemberRole) > 3)"}>}Account)

Thanks,

Krish

Re: Set analysis not working

tresB — Tue, 26 Nov 2019 10:07:50 GMT

Try removing $ from set modifier like:

=Count({<Str_Account__c={1},Flag={0},Level1={'Retail'},

TeamMemberRole={"= Count(TeamMemberRole) > 3"}>}Account)

Re: Set analysis not working

jaibau1993 — Tue, 26 Nov 2019 11:00:35 GMT

Hi! no need for that dollar sign expansion, try:

=Count({<Str_Account__c={1},Flag={0},Level1={'Retail'},TeamMemberRole={"=Count(TeamMemberRole) > 3"}>}Account)

Otherwise it seems correct. Regards,

Jaime.

Re: Set analysis not working

deepakkrish — Tue, 26 Nov 2019 10:51:44 GMT

Thanks for your reply . Condition is correct but i don't know why its showing wrong counts .

Re: Set analysis not working

deepakkrish — Tue, 26 Nov 2019 10:52:41 GMT

This gives nothing

Regards,

Deepakraj.

Re: Set analysis not working

deepakkrish — Tue, 03 Dec 2019 05:02:38 GMT

Its not working in front end. So , I write the condition script on backend .. Its working now.

Thanks for your immediate replies.

Thanks,

Krish