topic Re: Set Analysis Ignore Dimension in QlikView

Set Analysis Ignore Dimension

vhespinog — Mon, 19 Jun 2017 18:16:08 GMT

Hello

i have the follow requirement.

Formula: Previous Month + current Month - Previous Month when Fecha Liquidacion = current Month

i used the method AsOfMonth to calc the previous month. Works fine. Then i used the follow set analysis:

RangeSum(
          sum({$<
                  Tiempo={'Pasado'},  //Previous Month
                  bEsPender={1}
               >} Contrato),  
              
          
          Sum({$<
                  Tiempo={'Actual'},  //current Month
                  bEsPender = {1}
               >} Contrato),
          
          (sum({$<
                   Tiempo={'Pasado'}, //Previous month when Fecha liquidacion = AsOfYear
                   bEsPender={1},
                   [Fecha Liquidacion]= {'>=$(=MonthStart(Max(AsOfYear)))<=$(=MonthEnd(Max(AsOfYear)))'}
                >} Contrato)*-1)
          )

if i selected a AsOfYear works fine but if selected two ore more not working. The set analysis always take the max AsOfYear

Thanks

Re: Set Analysis Ignore Dimension

sunny_talwar — Mon, 19 Jun 2017 18:26:42 GMT

Would you be able to share a sample where we might be able to play around with this?

Thanks,

Sunny

Re: Set Analysis Ignore Dimension

vhespinog — Mon, 19 Jun 2017 18:46:17 GMT

Thanks Sunny

Re: Set Analysis Ignore Dimension

sunny_talwar — Mon, 19 Jun 2017 18:52:22 GMT

What do you expect to see in your chart when you have two years selected?

Re: Set Analysis Ignore Dimension

vhespinog — Mon, 19 Jun 2017 19:01:26 GMT

if i selected two month the set analysis take the max AsOfYear, i need take the value of the dimension

in the second image ene. 2017 should be 160

Re: Set Analysis Ignore Dimension

sunny_talwar — Mon, 19 Jun 2017 19:34:10 GMT

Check the attached

RangeSum(

sum({$<

Tiempo={'Pasado'},

bEsPender={1}

>} Contrato),

Sum({$<

Tiempo={'Actual'},

bEsPender = {1}

>} Contrato),

(Sum({$<Tiempo={'Pasado'}, bEsPender={1}>}Aggr(If([Fecha Liquidacion] >= MonthStart(Max(AsOfYear)) and [Fecha Liquidacion] <= MonthEnd(Max(AsOfYear)), Contrato), AsOfYear, [Fecha Liquidacion], %cont_id))*-1)

)

Re: Set Analysis Ignore Dimension

vhespinog — Mon, 19 Jun 2017 20:31:54 GMT

thank you very much for your help.