topic Re: Set Analysis with two sub-Set Analysis don't work in QlikView

Set Analysis with two sub-Set Analysis don't work

lprill — Sat, 16 Nov 2024 01:28:34 GMT

Hi,

i have the following Set-Analysis:

SUM( DISTINCT {< prospect={'B', 'C'}, Rolling12turnover={">=$(=vTurnover12Mon)"}, Rolling12purchasedates={">=$(=vPurchasedates12Mon)"}, Clientnr={"=sum( {< inv_date={[>=$(=date('$(vFilterdate)'))]} >} purchasedate)>=$(=$(vpurchasedatesSFilter))"}, Clientnr={"=sum( {< inv_datum={[>=$(=date('$(vFilterdate)'))]} >} turnover)>=$(=$(vturnoverSFilter))"} >} flag_check)

Looking quite simple to me, but it don't work.

The first three statements always work and also together with one of the last two, but the last two statements in the Set-Analysis don't work together.

Any Suggestions or tips on this?

Thank you in advance.

Re: Set Analysis with two sub-Set Analysis don't work

agigliotti — Mon, 20 Jan 2020 09:06:35 GMT

you can try with the below expression:

=SUM( DISTINCT
{
<
prospect = {'B', 'C'},
Rolling12turnover = {">=$(=vTurnover12Mon)"},
Rolling12purchasedates = {">=$(=vPurchasedates12Mon)"},

Clientnr = {"=sum(
{<
inv_date={[>=$(=date('$(vFilterdate)'))]}
>}
>
*
<
prospect = {'B', 'C'},
Rolling12turnover = {">=$(=vTurnover12Mon)"},
Rolling12purchasedates = {">=$(=vPurchasedates12Mon)"},

Clientnr = {"=sum(
{<
inv_datum={[>=$(=date('$(vFilterdate)'))]}
>}
turnover)>=$(=$(vturnoverSFilter))"}
>
}
flag_check )

I hope it helps.

Re: Set Analysis with two sub-Set Analysis don't work

lprill — Mon, 20 Jan 2020 11:46:17 GMT

Indeed this helps and did the job! 🙂

Thank you a lot!