Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
souadouert
Contributor III

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

Re: return to line

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')

Life is so rich, and we need to respect to the life !!!
roharoha
Valued Contributor III

Re: return to line

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
Contributor III

Re: return to line

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
Contributor III

Re: return to line

inline table anna

souadouert
Contributor III

Re: return to line

Capture.PNGCapture.PNG

souadouert
Contributor III

Re: return to line

Capture.PNG

Re: return to line

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

Life is so rich, and we need to respect to the life !!!
annafuksa1
Contributor III

Re: return to line

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
Contributor III

Re: return to line

in this case you need to make the table wider

Community Browser