topic Re: Selection in Francophones

Selection

MauriceLudo — Mon, 13 Jun 2016 16:18:39 GMT

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

sunny_talwar — Mon, 13 Jun 2016 16:22:14 GMT

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

Re: Selection

MauriceLudo — Mon, 13 Jun 2016 16:33:20 GMT

thanks Sunny

Here expression

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

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

)

if(

Nature_S='Collect',

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

)

Re: Selection

sunny_talwar — Mon, 13 Jun 2016 17:12:38 GMT

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

Re: Selection

MauriceLudo — Tue, 14 Jun 2016 08:42:03 GMT

voila

Re: Selection

MauriceLudo — Tue, 14 Jun 2016 08:44:36 GMT

voila

Re: Selection

sunny_talwar — Tue, 14 Jun 2016 09:41:17 GMT

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

Re: Selection

MauriceLudo — Tue, 14 Jun 2016 10:03:24 GMT

yes there was an access section,here without access section

Re: Selection

sunny_talwar — Tue, 14 Jun 2016 10:13:51 GMT

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

sunny_talwar — Tue, 14 Jun 2016 10:15:22 GMT

Alternatively, this should also work:

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

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

)

Re: Selection

flochi75 — Tue, 14 Jun 2016 10:24:10 GMT

it seems to work !

What does mean "smart" ?

Thanks

Florent

Re: Selection

MauriceLudo — Tue, 14 Jun 2016 10:24:26 GMT

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

Re: Selection

MauriceLudo — Tue, 14 Jun 2016 10:26:09 GMT

SMART is the name of alternative state

Re: Selection

flochi75 — Tue, 14 Jun 2016 10:30:58 GMT

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.