topic Re: compter avec set analysys in QlikView

compter avec set analysys

Wed, 25 Nov 2020 16:16:04 GMT

Hello everyoneI want to be able to count the number of a company for the date, company, workshop and categoryHere is the expression I tried to display sum ( aggr(count(distinct MatriculeRegie),%KEY_DATES,[SOCIETE],[ATELIER],[CATEGORIE]))The problem is that after the erexion my application ram so I want to rewrite this same expression in set analysis but I do not thank thank you for helping me

Re: compter avec set analysys

Anil_Babu_Samineni — Wed, 16 Aug 2017 08:43:03 GMT

Aggr used like Group By in SQL. So that, You can not do as i aware and what you written is good approach. May be explain little more related about RAM consumption ?? And how many used for %KEY_DATES

Re: compter avec set analysys

rahulpawarb — Wed, 16 Aug 2017 08:43:21 GMT

If you want to nested aggregate functions i.e. Sum of DISTINCT COUNT then AGGR is the best choice.

Apologies for not considering this in earlier response.

Regards!

Rahul Pawar

Re: compter avec set analysys

Wed, 16 Aug 2017 08:56:39 GMT

I can send you my application with qvd for you to try to see

Re: compter avec set analysys

Anil_Babu_Samineni — Wed, 16 Aug 2017 09:00:27 GMT

I don't think workfile needed to test. May be use simple

Count(DISTINCT MatriculeRegie) // Take one snapshot for Task manager where you are looking?

And then use, Aggr(...) then again take snap shot for that. We can notice where we troubleshoot.

Re: compter avec set analysys

Wed, 16 Aug 2017 09:09:02 GMT

Re: compter avec set analysys

Wed, 16 Aug 2017 09:17:56 GMT

Here is the slowness when I use the expression(sum ( aggr(count(distinct MatriculeRegie),%KEY_DATES,[SOCIETE],)[ATELIER],[CATEGORIE]))

Re: compter avec set analysys

Anil_Babu_Samineni — Wed, 16 Aug 2017 09:20:08 GMT

Right side not correct because you are just doing degrade some fields from expression. Your requirement is simple whether sum(aggr(...Set....),..,..)) in set analysis. My answer is no, What you written is correct approach only. please share images regards this part

camille kouaho wrote:

The problem is that after the execution my application ram so I want to rewrite this same expression in set analysis

Does this ram / RAM in your OS?

Re: compter avec set analysys

Wed, 16 Aug 2017 09:30:54 GMT

Ok i understood but it is when i added this table using the aggr that the application started to row ... so in conclusion what to do.