topic Re: Set Analysis Condition and Selection in QlikView

Set Analysis Condition and Selection

Thu, 13 Aug 2015 16:18:13 GMT

Hello There!

Is it possible to have a condition in Set Analysis and exclude the results when selecting dimension declared in set analysis?

=Sum(Aggr(

if(sum(Aggr(Sum ({<TipoDato={'NS_TipoServicio'}, Año={'$(vMaxAño)'}, Grupo={'Habitacional'} >}CanAliHue) ,CargoADescr))=0,0,

( sum(Aggr(Sum ({<TipoDato={'Movimiento'}, Año={'$(vMaxAño)'}, Grupo={'Habitacional'} >}CostoMov) ,CargoADescr ))

sum(Aggr(Sum ({<TipoDato={'NS_TipoServicio'}, Año={'$(vMaxAño)'}, Grupo={'Habitacional'} >}CanAliHue) ,CargoADescr)))

)

,CargoADescr))

Here is an example:

The original data

When I do a selection for dimension "Grupo" should be as the next image:

Re: Set Analysis Condition and Selection

sunny_talwar — Thu, 13 Aug 2015 16:22:08 GMT

You may do this:

Expression for Habitacional

If(GetFieldSelections(Grupo) = 'Barco' or GetFieldSelections(Grupo) = 'Construction', 0, YourCurrentExpression)

Similar ideas for other two expression

HTH

Best,

Sunny

Re: Set Analysis Condition and Selection

Kushal_Chawda — Thu, 13 Aug 2015 16:22:40 GMT

try this,

if( getfieldselections(Grupo)='Barcos', Your Expression, 0) for Bracos Text object

Likewise you can do for others

Re: Set Analysis Condition and Selection

sunny_talwar — Thu, 13 Aug 2015 16:26:30 GMT

Use this, as this should be a much better solution

Expression for Habitacional

If(SubStringCount(Concat(Grupo, ','), 'Habitacional') = 1, YourExpression, 0)

If(SubStringCount(Concat(DISTINCT Grupo, ','), 'Habitacional') = 1, YourExpression, 0)

Expression for Barco

If(SubStringCount(Concat(Grupo, ','), 'Barco') = 1, YourExpression, 0)

If(SubStringCount(Concat(DISTINCT Grupo, ','), 'Barco') = 1, YourExpression, 0)

Expression for Construccion

If(SubStringCount(Concat(Grupo, ','), 'Construccion') = 1, YourExpression, 0)

If(SubStringCount(Concat(DISTINCT Grupo, ','), 'Construccion') = 1, YourExpression, 0)

HTH

Best,

Sunny

Re: Set Analysis Condition and Selection

Kushal_Chawda — Thu, 13 Aug 2015 16:59:25 GMT

try this

Expression for Habitacional

If(Wildmatch(GetFieldSelections(Grupo), '*Habitacional*') , YourExpression, 0)

Expression for Barco

If(Wildmatch(GetFieldSelections(Grupo), '*Barco*') , YourExpression, 0)

Expression for Construccion

If(Wildmatch(GetFieldSelections(Grupo), '*Construccion*') , YourExpression, 0)

Re: Set Analysis Condition and Selection

Thu, 13 Aug 2015 17:41:55 GMT

Thank you everyone, all your answers where very helpful.

I just add

if(GetSelectedCount(Grupo)=0

At the beggining of expession when there is no selection, WILDMATCH function works perfect for me.

Thank you Kush141087‌

Re: Set Analysis Condition and Selection

Kushal_Chawda — Thu, 13 Aug 2015 17:54:39 GMT

I am glad that I was able to help