Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Bubskim
Contributor II
Contributor II

expressions in charts

Hi all.

Please help me with the expressions in my bar chart. There is one already here but I do not know what it means?

count({<[Subject] -= {"*Missing*file*"},
[exclude flag] = {0}>}[Subject])

 

Basically in my chart I need the date as today date or latests date , this is d-1.

I need to see the number of dl name , sent by, received time, and subject.

I also need help excluding things from my script like certain email distributions and subjects. So that it is not in my charts, unless I  can do this in my charts.

3 Replies
Lisa_P
Employee
Employee

This expression is counting the Subject where the Subject does not contain the text *Missing*file* and the exclude flag is not zero.

 

Bubskim
Contributor II
Contributor II
Author

Thanks! I can understand that the subject is not containing missing file, does that mean it is excluding it? Because I want to add more exclusions for the subject. Also what is a flag, do I need them each time I create an exclusion? I do not need it to count I need it to exclude. 

Brett_Bleess
Former Employee
Former Employee

Kimberly, try the following Design Blog post, this may help you on the exclusions piece.  There are also many other posts in this area too, just back the URL up to the qlik-design-blog/ and go to that page, you can enter search terms there to find more posts that may help with things.

https://community.qlik.com/t5/Qlik-Design-Blog/Excluding-values-in-Set-Analysis/ba-p/1471704

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.