Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Count and sum function

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.

2 Replies
Digital Support
Digital Support

The best thing to get responses on this issue would be to attach the QVW file, so people can see the data model as well as the object in which the expression is being used etc.  Not sure anyone is going to be able provide much without that or a lot more detailed description or at least the data model.  

About the best I can do are the following posts:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
MVP
MVP

I did not understand the exact issue. Can you elaborate?