[QlikSense - Chart Expression] How to add second value to a specific dimension ?

[Sansraison]

Hi there,

I am once again seeking your help !

I want to add to this chart a second field value for the column "SATPRO" :

The result will be 5 columns, "SATPRO" need to be divided into two separate columns depending on the field i calculate.

I can't figure out how to perform this / the best method to do this.

Here's the formula i used (which is wrong) :

Many thanks to the community !

Best regards,

[sunny_talwar]

May be you need another dimension in your chart.

If([Code du sondage] = 'SATPRO_EDH', FieldName) - > FieldName will be a field which divides SATPOR_EDH into 2 for your....

and then update your last two expressions to add  and FieldName = 'Section1' and FieldName = 'Section2'

[Sansraison]

Sadly not working ! 😞

But thanks for the tip, i have done something else :

But i can't name each column like i want to... and can't center them properly.

Maybe you can help, or i'll figure out something else.

As always, thank you for your great support ! 🙂

[sunny_talwar]

Try removing the dimension for this chart now

[Sansraison]

Well, it just show a blank area, the selection cannot generate data to display... 😞

[sunny_talwar]

What if you add number 1 as your calculated dimension

[Sansraison]

Hello Sunny,

What do you mean by "adding number 1 as a calculated dimension" ?

Create a dimension with "=1" ?

Thanks !

[sunny_talwar]

ya, try that

[Sansraison]

Sadly, that's not working ! 😞

[sunny_talwar]

What do you see when you do that? can you share a screenshot?