Variable dimensions

[Anonymous]

This must be easy I hope: I've create a variable vCritDimension which content is:

=If(GetSelectedCount(Dimension)>0,CONCAT(DISTINCT Dimension,  ', '))

Where Dimension is a result of:

LOAD * INLINE [

Dimension

'Cliente NIF'

'Articulo'

];

I have a list Dimension and use the selected values to show or hide dimensions with the next condition, and it works:

=GetSelectedCount(Dimension)>0 and  SubStringCount( GetFieldSelections(Dimension), 'Cliente NIF')>=1

But when I use vCritDimension in an Aggr function it's not understood as dimensions... Do I miss something with $ or whatever??

[sunny_talwar]

May be change your variable to this

=If(GetSelectedCount(Dimension)>0, Concat (DISTINCT '[' & Dimension & ']',  ', '))

and use your variable within a dollar sign expansion

$(=vCritDimension) or $(=$(vCritDimension))

[Anonymous]

Sunny, it works but have a problem:

If I use one (of the two available) dimension, and click on the calculated dimension, it's filtered correctly, but if I use two dimensions, the clicking/filtering behaviour is not correct. This is the formula used in the calculated dimension:

=Aggr(

If(Sum({<Y = {"$(=[Año 1])"}, Origen = {"$(=[Origen C1])"}>}[Venta Neta])=0 and sum({<Y = {"$(=[Año 2])"}, Origen = {"$(=[Origen C2])"}>}[Venta Neta])<>0,'Ventas perdidas',

If(Sum({<Y = {"$(=[Año 2])"}, Origen = {"$(=[Origen C2])"}>}[Venta Neta])=0 and sum({<Y = {"$(=[Año 1])"}, Origen = {"$(=[Origen C1])"}>}[Venta Neta])<>0,'Ventas nuevas',

If(Sum({<Y = {"$(=[Año 1])"}, Origen = {"$(=[Origen C1])"}>}[Venta Neta])>=Sum({<Y = {"$(=[Año 2])"},Origen = {"$(=[Origen C2])"}>}[Venta Neta]), 'Incremento ventas',

If(Sum({<Y = {"$(=[Año 1])"}, Origen = {"$(=[Origen C1])"}>}[Venta Neta])< Sum({<Y = {"$(=[Año 2])"},Origen = {"$(=[Origen C2])"}>}[Venta Neta]), 'Disminución ventas',

)))), $(=vCritDimension))

It's only the clicking/filtering function, and I can live with it, but I don't understand it, showed information is correct, and I can expand and contract correctly... I just cannot follow the logic,when IO click some information is filtered, and other is not, but it seems that there's no logical explanation.

[sunny_talwar]

the clicking/filtering behaviour is not correct.

What exactly are you clicking/filtering? In the chart itself? Would you be able to share a sample to demonstrate the issue?

[Anonymous]

Yes,. it is in the chart itself, on the output value in the calculated dimension column, I'll try to update a small example I have been using...

[sunny_talwar]

Ya I can see why it would be a problem. Not sure if I have a solution for this problem.

[Anonymous]

Eh? I can't find the attach function?!?!?!

[Anonymous]

Here it is...

Having [Articulo] y [Cliente NIF] selected, when you click in Example a calculated dimension, it doesn't work propperly...

[sunny_talwar]

Checking...

[sunny_talwar]

Not sure how many dimensions are possible, but you might have to do something like what I did to make it work....