Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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 (1)
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