- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please kindly assist me in writing the expression correctly .?
Hi All ,
Please kindly assist me in writing the expression correctly . I am attaching my sample model. I trying to explain what I need as my result.
For eg,
Client Id - 9910206389188 , I have only one deal_id 13067504 but the dealstate_id is 71 and 33 .
So, my requirement is on the `Wesbank DIC ` for report ' One month select DIC Overview' -
it should on have - DIC amount as - 5677.47 for any one of the dealstate_id for unique deal_id .
But the report ' One month select DIC Overview' is summing up to R 11354,94
Where as , its not the case for the other ClientID - 9805290108086 and dea_id - 12757731
For eg,
There is such case , where deal_id is different and dealstate is also different , see below screenshot - in such scenario , the 'Wesbank DIC' is working correctly.
Sample attached.
Thanks in advance.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
use distinct before if statement like
=sum({<bank={'Wesbank'}> }DISTINCT if(LatestForPodium ='1' or LatestForState ='1', dicAmount))
Regards,
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
use distinct before if statement like
=sum({<bank={'Wesbank'}> }DISTINCT if(LatestForPodium ='1' or LatestForState ='1', dicAmount))
Regards,
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂