Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

deepakkrish
Contributor

Set analysis not working

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

1 Solution

Accepted Solutions
deepakkrish
Contributor

Re: Set analysis not working

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

 

Thanks for your immediate replies.

 

Thanks,

Krish

View solution in original post

5 Replies
MVP
MVP

Re: Set analysis not working

Try removing $ from set modifier like:

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

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

Partner
Partner

Re: Set analysis not working

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.

deepakkrish
Contributor

Re: Set analysis not working

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

deepakkrish
Contributor

Re: Set analysis not working

This gives nothing

 

Regards,

Deepakraj.

deepakkrish
Contributor

Re: Set analysis not working

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

 

Thanks for your immediate replies.

 

Thanks,

Krish

View solution in original post