topic Re: Filtrer dimension set analysis in Francophones

Set analysis : Filter dimension

jmialoundama — Mon, 15 Jan 2018 08:45:04 GMT

Bonjour,

Je souhaiterai avoir tous les 'Lib.Rayon(ref)' quand ma colonne 'Cd.Univers(ref)' = 83 avec un set analysis.

Je penses utiliser la fonction "IF" dans mon expression, cependant je bloque un peu

Merci d'avance

Re: Filtrer dimension set analysis

Anil_Babu_Samineni — Mon, 15 Jan 2018 08:48:59 GMT

Looks set analysis syntax wrong? Try this? The first one strike through and add parenthesis in the end

=Sum({$<[Cd. Univers (ref)]={'83'}>} [Lib. Rayon (ref)])

Re: Filtrer dimension set analysis

jmialoundama — Mon, 15 Jan 2018 08:53:35 GMT

Hello Anil,

Thanks you for your feedback,

I try you syntax but i have this error:"Dimension is not valid"

Re: Filtrer dimension set analysis

Anil_Babu_Samineni — Mon, 15 Jan 2018 08:55:05 GMT

It's clearly stating the issue, What dimension you used for. Can you hit Fx and check the validation ??

Re: Filtrer dimension set analysis

jmialoundama — Mon, 15 Jan 2018 08:58:50 GMT

That is the syntax i use in "fx" :

But , I think i need to use "if" expression for resolv my problem

if [Cd. Univers (ref)]={'83'} then i want to see the [Lib. Rayon (ref)].

But i don't know how to transform that in QS becuase i'm begginer.

Re: Filtrer dimension set analysis

Anil_Babu_Samineni — Mon, 15 Jan 2018 09:01:03 GMT

In UI the set analysis tool is same for QIX engine to both. To your question. Can you try that expression as measure / Sum(1) and Dimension as [Lin. Rayon (ref)]

Update - There is a text in image from that field. Hence, it won't happen. Can you help us your intend to show

Re: Filtrer dimension set analysis

brunobertels — Mon, 15 Jan 2018 09:07:23 GMT

Bonjour

Sum, Avg, Min, Max, etc sont des agrégations qui requièrent l'utilisation de Aggr() pour être utilisées comme dimension

Donc essayes ceci

Aggr(

Sum({$<[Cd.Univers(ref)]={'83'}>} [Lib. Rayon (ref)])

,[Lib. Rayon (ref)]

)

Re: Filtrer dimension set analysis

jmialoundama — Mon, 15 Jan 2018 09:15:40 GMT

Bonjour Bruno,

J'ai utilisé votre syntax sauf que je ne vois pas les libélés rayons qui sont égaux à 83, à la place je vois que des zéros.

Au lieu de voir ceci :

Re: Filtrer dimension set analysis

Re: Fonction IF

vinieme12 — Mon, 15 Jan 2018 09:20:52 GMT

Hi,

You can't SUM() a text field!

if you only want to see [Lib. Rayon (ref)] where [Cd.Univers(ref)]=83 use the ONLY() function in a ListBox with AGGR or below sum Function in a Table

in a ListBox

AGGR( ONLY ( {$<[Cd.Univers(ref)]={'83'}>} [Lib. Rayon (ref)] ) , [Lib. Rayon (ref)] )

OR in a table with

Dimension = [Lib. Rayon (ref)]

Measure = Sum({$<[Cd.Univers(ref)]={'83'}>}1)

Re: Fonction IF

YoussefBelloum — Mon, 15 Jan 2018 09:26:57 GMT

My bad ! i didn't even look at the table above..

Re: Filtrer dimension set analysis

jmialoundama — Mon, 15 Jan 2018 09:31:39 GMT

Yes it's work !

Thanks you

=AGGR( ONLY ( {$<[Cd. Univers (ref)]={'83'}>} [Lib. Rayon (ref)] ) , [Lib. Rayon (ref)] )

Re: Fonction IF

vinieme12 — Mon, 15 Jan 2018 09:32:01 GMT

happens with me too sometimes

Re: Fonction IF

intergnek — Mon, 15 Jan 2018 11:32:34 GMT

Ca marche très bien

Re: Set analysis : Filter dimension

jmialoundama — Mon, 15 Jan 2018 13:04:02 GMT

Yes after i remember your answer with "onyl" function

Re: Set analysis : Filter dimension

brunobertels — Mon, 15 Jan 2018 15:36:34 GMT

Bonjour

Oui ne relisant les réponses des uns et des autres , je vois que j'ai mis SUM et non ONLY

Du coup çà ne peut pas marcher avec SUM

Bruno