Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Highlighted
Not applicable

Voir le nom au lieu de l'ID

Bonjour à tous,

Je travaille sur QlikSense Desktop et je n'arrive pas à réaliser quelque chose.

J'aimerai pouvoir afficher un histogramme dans lequel j'ai pour mesure la somme de 2 valeurs (pas de problème là-dessus) et comme dimension l'ID, en revanche je souhaiterai voir apparaitre le nom de la modalité et non l'ID. Est-ce possible de réaliser cela ?

(Si je mets le nom comme dimension problème, certaines valeurs ont le même nom )

Merci d'avance

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Voir le nom au lieu de l'ID

=Dual(Name, ID) seems to work:

c216018.png


talk is cheap, supply exceeds demand
8 Replies
MVP & Luminary
MVP & Luminary

Re: Voir le nom au lieu de l'ID

Simply use the name as dimension instead of the ID.


talk is cheap, supply exceeds demand
Not applicable

Re: Voir le nom au lieu de l'ID

Thank you but it's not my problem. I'm trying to write in English because I think the traduction is bad.

I want to use ID as dimension but see name of the values (I have values which have the same name however I want to differenciate them...)

MVP & Luminary
MVP & Luminary

Re: Voir le nom au lieu de l'ID

Perhaps. If I understand you correctly you want a histogram (a specialized type of bar chart) with ID as dimension and a measure that's something like RangeSum(ValueA,ValueB).

Then, for a reason I do not understand, you want to use another field for the labels of the x-axis. That doesn't make sense to me. What's the relation between ID and the name field? Are there multiple ID values per name value or is it a 1-to-1 relation?

Perhaps you can use a calculated dimension like =Dual(Name, ID)


talk is cheap, supply exceeds demand
Not applicable

Re: Voir le nom au lieu de l'ID

That's really nice to get help 🙂


To help you to understand my problem this is the kind of things that I have :

Example :

ID     Name     Cost

1      A              12                        

2      A               9

3      B              13     


It's really simplified. Hope you understand better my problem now.


MVP & Luminary
MVP & Luminary

Re: Voir le nom au lieu de l'ID

Ok, and using that example as data for a bar chart how many bars should the chart show, 2 or three? And how is the value of the bar calculated?


talk is cheap, supply exceeds demand
Not applicable

Re: Voir le nom au lieu de l'ID

The chart should show 3 bars, but I found a solution : dimension -> ID&'-'&name

That's not what I exactly expected however it's ok

Thank you for you time

Sincerely

Augustin

MVP & Luminary
MVP & Luminary

Re: Voir le nom au lieu de l'ID

=Dual(Name, ID) seems to work:

c216018.png


talk is cheap, supply exceeds demand
Not applicable

Re: Voir le nom au lieu de l'ID

An other solution ! Thank you !