topic Aggr with set analysis in QlikView

Aggr with set analysis

nikita23 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I want to group by my required data on the basis of DF_PACKNR with distinct POD numbers so I have used the below aggr function for it and its working fine.

count(aggr(distinct(DF_POD),DF_PACKNR))

But Now I want to apply one more condition on it with different column where need to sort the data on the basis of DF_USER='VR1'.

after applying set analysis on it, Its showing no data.

could you please provide some solution for it to apply set analysis with Aggr.

Re: Aggr with set analysis

Vegar — Thu, 13 Jun 2019 07:03:14 GMT

It would be easier to provide if you could post some sample data and an example on how you are trying to apply Set to your expression.

Are you applying the set inside the count or inside the aggr or both?
Does your SET look like this: {$<DF_USER={'VR1'}>} ?

Re: Aggr with set analysis

nikita23 — Thu, 13 Jun 2019 07:24:11 GMT

Hi Vegar,

I am applying like this as below:

AGGR(COUNT(DISTINCT {<DF_USER={'VR1'}>} DF_POD), DF_PACKNR)

Re: Aggr with set analysis

Vegar — Thu, 13 Jun 2019 10:48:19 GMT

Have you tried
AGGR( {<DF_USER={'VR1'}>} COUNT(DISTINCT {<DF_USER={'VR1'}>} DF_POD), DF_PACKNR)
?

Re: Aggr with set analysis

sunny_talwar — Thu, 13 Jun 2019 11:31:51 GMT

Have you tried this?

Count({<DF_USER = {'VR1'}>} Aggr(DISTINCT Only({<DF_USER = {'VR1'}>} DF_POD), DF_PACKNR))

or this

Count(Aggr(DISTINCT Only({<DF_USER = {'VR1'}>} DF_POD), DF_PACKNR))

Re: Aggr with set analysis

nikita23 — Fri, 14 Jun 2019 10:39:12 GMT

Hi Sunny,

Its now working fine in our scenario I mean its giving wrong counts.

Re: Aggr with set analysis

sunny_talwar — Fri, 14 Jun 2019 10:56:55 GMT

Would you be able to share a sample to show what you are getting and provide the number/s you are hoping to get?