topic Where is my mistake? in QlikView

Where is my mistake?

vmonitor — Tue, 25 Aug 2020 06:23:23 GMT

I want to create an alert that would display a list of providers for which the traffic is more than 1000 contexts and the share of 503 codes is more than 20%. For this I do this.

= 'on these providers, with traffic> 1000 contexts, the share of 503 code> 20%:'chr(10) &chr(10)& chr(13)&
Concat(DISTINCT{<provider={'=Count ({<[Code]={"503"},dir={"Out (*"}>}context)/Count ({<dir={"Out (*"}>}context)>0.2
and Count ({<dir={"Out (*"}>}context)>1000'}>}provider, chr(13))

As a result, a list is issued at the output, in which this "Count ({<Direction = {" Out (* "}>} Context)> 1000 is displayed, and as for the criterion for the share of 503 code, I don’t understand how it works (i.e. very often providers are found for which the share of 503 codes is below 0.2)

Re: Where is my mistake?

tresB — Tue, 25 Aug 2020 06:35:46 GMT

Without going much into the detail - a quick fix you can try. Try replacing single quotes with back quotes for set analysis part, like:

Concat(DISTINCT{<provider={`=Count ({<[Code]={"503"},dir={"Out (*"}>}context)/Count ({<dir={"Out (*"}>}context)>0.2
and Count ({<dir={"Out (*"}>}context)>1000`}>}provider, chr(13))

Re: Where is my mistake?

vmonitor — Tue, 25 Aug 2020 09:59:44 GMT

I have got the same resalt. 😞

Re: Where is my mistake?

vmonitor — Tue, 25 Aug 2020 10:01:52 GMT

How can I write this condition using aggr and if?

Re: Where is my mistake?

vmonitor — Wed, 02 Sep 2020 08:32:34 GMT

I have tried this one, but nothing changed.

= 'on these providers, with traffic> 1000 contexts, the share of 503 code> 20%:'chr(10) &chr(10)& chr(13)&
concat(aggr(if(COUNT({<Code={"503"},dir={"Out (*"}>}[Call ID])/COUNT({<dir={"Out (*"}>}[Call ID]) > 0.2
and Count ({<dir={"Out (*"}>}context)>1000'}>}provider, chr(13))

Re: Where is my mistake?

Brett_Bleess — Tue, 08 Sep 2020 17:56:04 GMT

The following Design Blog post may help in regard to AGGR and Set Analysis:

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

@tresB Just wanted to hit you up, as I know we have been having issues with the notifications on things, if you can think of anything else, shout.

Cheers,
Brett

Re: Where is my mistake?

tresB — Wed, 09 Sep 2020 06:00:43 GMT

Thank you @Brett_Bleess .

@vmonitor , Could you please share a sample app where we can see the issue w.r.t.what you are expecting and what you are getting?