topic Re: Converting into set analysis in QlikView

Converting into set analysis

sakshikaul — Mon, 31 Jan 2022 15:37:52 GMT

Hi,

I want to covert following expression into set analysis and add filters([prod date] and [manager name]) like below expression given as an eg ) to the expression below

=interval(div(sum(aggr(avg(distinct(TI_AUX)),agent_ID,DT_time_key)),3600)

&':'&(div(sum(aggr(avg(dstinct(TI_AUX)),agent_ID,DT_time_key)),60)-div(sum(aggr(avg(dstinct(TI_AUX)),agent_ID,DT_time_key)),3600)*60,'HH:mm')

I have already written an expression for some another requirement using set analysis. In a similar manner I want to convert the above expression with filters

eg-

=num(sum({1<[sujct]={'vol'},[prod date]=p[prod date],[manager name]=p[manager name])>[volume count]),'#,##0')

Please help

Re: Converting into set analysis

chrismarlow — Mon, 31 Jan 2022 17:27:00 GMT

Hi,

I think generally you will need your set at every point you aggregate (so for each sum/avg in the expression). Similar to the reply here;

Solved: Aggr Nested in Set Analysis - Qlik Community - 216128

Cheers,

Chris.

Re: Converting into set analysis

Shepherd69 — Fri, 11 Feb 2022 03:49:16 GMT

@myccpay wrote:

Hi,

I want to covert following expression into set analysis and add filters([prod date] and [manager name]) like below expression given as an eg ) to the expression below

=interval(div(sum(aggr(avg(distinct(TI_AUX)),agent_ID,DT_time_key)),3600)

&':'&(div(sum(aggr(avg(dstinct(TI_AUX)),agent_ID,DT_time_key)),60)-div(sum(aggr(avg(dstinct(TI_AUX)),agent_ID,DT_time_key)),3600)*60,'HH:mm')

I have already written an expression for some another requirement using set analysis. In a similar manner I want to convert the above expression with filters

eg-

=num(sum({1<[sujct]={'vol'},[prod date]=p[prod date],[manager name]=p[manager name])>[volume count]),'#,##0')

Please help

It's sometimes convenient to make use of variables in set expressions to make them even more dynamic. We've previously discussed how variables alone are used. We will now go through some examples of Set Analysis expressions that make use of variables instead of hard-coded field values.