Dimension Value in a table display '-'. How can I show the real value of my dimension ?

[Rskubis]

Hi everyone, 

Hope you can help me 🙂 

I have an issue in a table on QlikSense. I will try to summarize as I can :

I have a table with 7 columns : Name of representative / Client Name / Client Code  as dimensions and the other 4 columns are measures. 

For example the second column is done with the following set analysis : 

=aggr(ONLY({<[Cli.MixingPaint]={'MIXING PEINTURE'}>}[Cli.Nom]),[Cli.Nom]) in order to make a selection and only show Clients that are 'Mixing clients'. For a majority of them, I have the right client Name in the second column and the right client code in the third column. But for those last ones, i have '-'. 

I Have already checked  'include null values' so it shows the rows with '-'. 

How can I change my set analysis in order to change '-' with the real value. For instance Capasso Frédéric show '-' but in reality on my dataset the client name is "garage gerard" and the code is "06254587". So, how Can I change '-' by "Garage Gerard" ? 

I am a beginner in Qliksense. Pardon my lack of knowledge,

Thank you for your help and time ! see you

#IsNull #Aggr

[Rskubis]

Maybe I am stupid (or a little bit tired ^^).

Instead of using "Aggr" I used "if" and it works great. Showing each dimension's values. 

So I replace : 

- =aggr(ONLY({<[Cli.MixingPaint]={'MIXING PEINTURE'}>}[Cli.Nom]),[Cli.Nom])

by 

- If([Cli.MixingPaint]='MIXING PEINTURE', [Cli.Nom])

BUT if you can explain why "Aggr" do not show up dimension's values unlike "IF". I am here to learn 😄 

Thanks !