topic Set Analysis function in QlikView

Set Analysis function

Tue, 22 May 2012 18:18:51 GMT

Hi all, I want to translate the sentence below to set analysis.

=if(Date(T010_InicioVigencia,'DD/MM/YYYY') <= Date(max(Date) ,'DD/MM/YYYY') and Date(DataFinalVigencia,'DD/MM/YYYY') >= Date(min(Date) ,'DD/MM/YYYY'),sum(Price),'')

Prety much like that.

sum({$<Ano_Emissao_Documento= , Ano_Cancelamento_Documento={$(vAnoEmissao)}>}Price)

any clues???

thanks

Set Analysis function

swuehl — Tue, 22 May 2012 18:23:52 GMT

It could be looking like

=sum({<T010_InicioVigencia = {"<=$(=max(Date))"}, DataFinalVigencia = {">=$(=min(Date))"} >} Price)

Hope this helps,

Stefan

Set Analysis function

Tue, 22 May 2012 18:32:18 GMT

Thank you.

It works perfect.