Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

return to line

I use this list of value for a dimension,

=ValueList(dual('Crédits au Particuliers',1),dual('Conquéte',2),dual('PACKS HG',3),dual('PACKS SILVER',4),dual('Epargne',5),dual('Produits stratégiques vol',6),dual('TRPP SYNTH.Hors depots',7))


I want to insert a return to line in an example string: Crédits au Particuliers

12 Replies
Anil_Babu_Samineni

I may not sure, What are you expecting. What is the case you are using Dual function here.

=ValueList('Crédits au Particuliers','Conquéte','PACKS HG',3,'PACKS SILVER','Epargne','Produits stratégiques vol','TRPP SYNTH.Hors depots')

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable

in an expression you could refer to valuelist() like that:

if(ValueList(dual('Crédits au Particuliers',1),dual('Conquéte',2),dual('PACKS HG',3),dual('PACKS SILVER',4),dual('Epargne',5),dual('Produits stratégiques vol',6),dual('TRPP SYNTH.Hors depots',7))

='Crédits au Particuliers','X')

annafuksa1
Creator III
Creator III

it depend how you want to use is in chart , list box, text box the formula will be different , but will suggest to create inline table with this values

souadouert
Specialist
Specialist
Author

inline table anna

souadouert
Specialist
Specialist
Author

Capture.PNGCapture.PNG

souadouert
Specialist
Specialist
Author

Capture.PNG

Anil_Babu_Samineni

May be check the "Size to Data" and meantime, You can elapse if you want

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
annafuksa1
Creator III
Creator III

so I will create inlene table with fields

LOAD * INLINE [

_%TabName, _%TabNo

Crédits au Particuliers,1

Conquéte,2

...

];

and use function

=FirstSortedValue(_%TabName, _%TabNo, 1)

annafuksa1
Creator III
Creator III

in this case you need to make the table wider