Qlik Community

Ask a Question

Groupe des Utilisateurs Francophones

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
MauriceLudo
Creator II
Creator II

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 .

1 Solution

Accepted Solutions
sunny_talwar

Alternatively, this should also work:

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

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

)

View solution in original post

13 Replies
sunny_talwar

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

Capture.PNG

MauriceLudo
Creator II
Creator II
Author

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

)

sunny_talwar

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

MauriceLudo
Creator II
Creator II
Author

voila

MauriceLudo
Creator II
Creator II
Author

voila

sunny_talwar

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

MauriceLudo
Creator II
Creator II
Author

yes there was an access section,here without access section

sunny_talwar

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 )

)

sunny_talwar

Alternatively, this should also work:

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

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

)

View solution in original post