Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bonjour,
Voici ce que j'aimerai faire : rajouter les parenthèses ci-dessous
( [SRT] = {"val1","val2"} >*< [SOCTN] = {"val3","val4"} )
>+<
( [SRT] = {"val5","val6"} >*< [SOCTN] = {"val7"} )
Comment faire comprendre à Qlik le système de parenthèse dans ce cas ?
I think it should look like:
{
( < [SRT] = {'val1', 'val2'} > * < [SOCTN] = {'val3', 'val4'} >)
+
(< [SRT] = {'val5', 'val6'} > * < [SOCTN] = {'val7'} >)
}
Je vous remercie de votre réponse,
J'ai trouvé une solution à mon problème :
I think it should look like:
{
( < [SRT] = {'val1', 'val2'} > * < [SOCTN] = {'val3', 'val4'} >)
+
(< [SRT] = {'val5', 'val6'} > * < [SOCTN] = {'val7'} >)
}
Le + est toujours considéré comme un OU ?
Yes.
+ is OR and * is AND
Après de multiple tentative, je rencontre un problème, il semblerais que la syntaxe sois correcte mais le filtre ne s'applique pas !
The combination of inner and outer set analysis is not trivial. The announcement of this feature and the description within the help are creating an impression that they are replaceable to each other and simple in the usage but by reading it carefully there are some dependencies and exceptions mentioned - unfortunately without explaining it in detail.
If I remember correctly it states that by any kind of conflict the most inner set statement will win - overwriting the other set statements. I think what you have created is going in following direction:
Je te remercie pour ta réponse complète.
Le fait que l'ensemble interne prime sur l'externe est ce que je souhaite.
Plus précisément, je souhaite créer un ensemble de donnée puis y appliquer un pourcentage donc en prenant qu'une partie de ces données d'où le :
I'm not sure if it's suitable for your scenario but in several cases I could outsource some conditions and using it then as a boolean check against the base-aggregation. This may look like:
[SOCTN]))
If this isn't working I suggest to create a table-box with the relevant fields + the relevant fields within list-boxes and then looking if the existing data-set provides the wanted selections. If it's not possible to align the appropriate rows there you couldn't apply it per set analysis.
Je vous remercie de votre réponse,
J'ai trouvé une solution à mon problème :