13 Replies Latest reply: Jun 14, 2016 6:30 AM by Florent Lelarge-Otiniano

# Selection

Bonjour,

pourriez-vous s'il vous plait m'explique pourquoi qd je sélectionne G1000 de dimension RU, j'ai les autres RU que s'affiche.

ci-joint copie écran, merci d'avance .

• ###### Re: Selection

Seems like two of your expressions are using set analysis to ignore selection in RU field

• ###### Re: Selection

thanks Sunny

Here expression

1- if(Dimensionality()=2 or Nature_S='Collect',

sum({\$< YearS={"=\$(=Max(YearS))"}, MonthS={"<=\$(=Max(MonthS))"} >}ACTUALERP_S/Weight )

)

2-

if(

Nature_S='Collect',

[Actuals N YTD ERP] - [Actuals N YTD SMART],0

)

• ###### Re: Selection

You expressions look good to me, would it be possible to share a sample of your application to check it out?

• ###### Re: Selection

voila

• ###### Re: Selection

voila

• ###### Re: Selection

When I try to open this, it is showing me 'access denied' error. Do you have section access?

• ###### Re: Selection

yes there was an access section,here without access section

• ###### Re: Selection

I think you were using alternate state and you used \$ in your expression instead of SMART:

if(Dimensionality()=2 or Nature_S='Collect',

sum({\$< YearS={"=\$(=Max(YearS))"}, MonthS={"<=\$(=Max(MonthS))"} >}ACTUALERP_S/Weight )

)

if(Dimensionality()=2 or Nature_S='Collect',

sum({SMART< YearS={"=\$(=Max(YearS))"}, MonthS={"<=\$(=Max(MonthS))"} >}ACTUALERP_S/Weight )

)

• ###### Re: Selection

Alternatively, this should also work:

if(Dimensionality()=2 or Nature_S='Collect',

sum({<YearS={"=\$(=Max(YearS))"}, MonthS={"<=\$(=Max(MonthS))"} >}ACTUALERP_S/Weight )

)

• ###### Re: Selection

thank you very much , a little trick you have to be an expert like you

• ###### Re: Selection

it seems to work !

What does mean "smart" ?

Thanks

Florent

• ###### Re: Selection

SMART is the name of alternative state

• ###### Re: Selection

ahhh tu utilises des états alternatifs...

Mince, je n'avais pas vu...

Il y a qq années, lors de ma formation Qlik, l'intervenant nous avait déconseillé cette utilisation, car on se fait facilement des croches-pieds...

Ok, je comprends mieux.

Désolé si je ne pouvais pas t'aider sur ce point, mais je l'ai suivi car il m'intéressait...

Florent.