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

Count of ID with sum condition

Hi All,

This is my expression , I want to calculate the ID based on the below condition.I wrote some expression but the value changing when i select multiple stamp.

Condition: Calculate ID ,

if sum of price is less than or equal to 500 and status not equal to lost and stage equal to propse , booked and group not equal to owner and care.

Dimension : TimeStamp

expression: =(1-(Count({<ID={"=Sum(Price) <= 500"}, Status -= {'Lost'}, Stage = {'Propose', 'Booked'},
[Group]-={'owner','care'}>}DISTINCT  ID)
/
Count({<Stage-={'Cancelled ','Sales'}>}DISTINCT  ID)))

 

Regards,

Deep.

Labels (2)
1 Solution

Accepted Solutions
deepakkrish
Creator
Creator
Author

Thanks for the quick reply @sunny_talwar . 

I wrote sum of condition in script and apply it on expression . It's working now .

Thanks,

Deep.

View solution in original post

3 Replies
deepakkrish
Creator
Creator
Author

sunny_talwar

You mean when you select multiple timestamps? Do you want to ignore selections in timestamp field?

deepakkrish
Creator
Creator
Author

Thanks for the quick reply @sunny_talwar . 

I wrote sum of condition in script and apply it on expression . It's working now .

Thanks,

Deep.