Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
This expression is counting the Subject where the Subject does not contain the text *Missing*file* and the exclude flag is not zero.
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.
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