topic Re: return to line in QlikView

return to line

souadouert — Mon, 24 Apr 2017 10:38:55 GMT

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

Re: return to line

Anil_Babu_Samineni — Mon, 24 Apr 2017 10:42:10 GMT

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

Re: return to line

Anonymous — Mon, 24 Apr 2017 10:46:30 GMT

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

Re: return to line

annafuksa1 — Mon, 24 Apr 2017 10:49:36 GMT

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

Re: return to line

souadouert — Mon, 24 Apr 2017 12:32:41 GMT

inline table anna

Re: return to line

souadouert — Mon, 24 Apr 2017 12:35:54 GMT

Re: return to line

souadouert — Mon, 24 Apr 2017 12:36:33 GMT

Re: return to line

Anil_Babu_Samineni — Mon, 24 Apr 2017 12:41:23 GMT

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

Re: return to line

annafuksa1 — Mon, 24 Apr 2017 12:41:43 GMT

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)

Re: return to line

annafuksa1 — Mon, 24 Apr 2017 12:42:12 GMT

in this case you need to make the table wider

Re: return to line

souadouert — Mon, 24 Apr 2017 12:48:18 GMT

when i find this option?

Re: return to line

Anil_Babu_Samineni — Mon, 24 Apr 2017 12:49:54 GMT

From Layout Tab. I think so

Re: return to line

annafuksa1 — Mon, 24 Apr 2017 12:57:08 GMT

no right click inside the table (same to open the properties) and you wil have it as one of the options i think 4th,

or you can change it by moving the like (same way as in Excel)