Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakkrish
Creator
Creator

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

Labels (3)
1 Solution

Accepted Solutions
deepakkrish
Creator
Creator
Author

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
tresesco
MVP
MVP

Try removing $ from set modifier like:

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

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

jaibau1993
Partner - Creator III
Partner - Creator III

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
Creator
Creator
Author

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

deepakkrish
Creator
Creator
Author

This gives nothing

 

Regards,

Deepakraj.

deepakkrish
Creator
Creator
Author

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

 

Thanks for your immediate replies.

 

Thanks,

Krish