topic Set Analysis in QlikView

Set Analysis

marco_puccetti — Fri, 26 Jun 2015 10:47:11 GMT

Hello i need to let this script to be selection indipendent:

Count({<RICHIESTA_APERTURA={">=$(=(max(RICHIESTA_APERTURA)-6))<=$(=max(RICHIESTA_APERTURA))"}> }DISTINCT NUMERO_PROPOSTA)

How can i do?

Thanks

Marco

Re: Set Analysis

m_woolf — Fri, 26 Jun 2015 12:04:27 GMT

Isn't it simply: Count({1<..........

Re: Set Analysis

Anonymous — Fri, 26 Jun 2015 12:05:15 GMT

Use '1' as set identifier:

Count({1<RICHIESTA_APERTURA={">=$(=(max({1}RICHIESTA_APERTURA)-6))<=$(=max({1}RICHIESTA_APERTURA))"}> }DISTINCT NUMERO_PROPOSTA)

Re: Set Analysis

marco_puccetti — Fri, 26 Jun 2015 13:10:09 GMT

And on this statement:

Num(Avg(Date(DT_APERTURA_CONTO) - Date(DT_RICHIESTA_APERTURA,'DD-MM-YYYY')),'00')

Thanks

Marco

Re: Set Analysis

sunny_talwar — Fri, 26 Jun 2015 13:28:54 GMT

Try this:

=Num(Avg({1} Date(Only({1} DT_APERTURA_CONTO)) - Date(Only({1} DT_RICHIESTA_APERTURA),'DD-MM-YYYY')),'00')

Re: Set Analysis

marco_puccetti — Fri, 26 Jun 2015 13:31:48 GMT

Is it necessary the use of Only?

Marco

Re: Set Analysis

sunny_talwar — Fri, 26 Jun 2015 13:35:38 GMT

‌If you want to try without them.... You can.... See if without them makes sense, but then you won't be able to use {1} within date function. So try with and without them and see if it makes any difference or not

Re: Set Analysis

marco_puccetti — Fri, 26 Jun 2015 14:43:41 GMT

Thanks

Marco

Re: Set Analysis

sunny_talwar — Fri, 26 Jun 2015 14:44:34 GMT

If it worked, then I would request you to mark correct and helpful answers to close this thread.

Best,

Sunny