Add Column in table

[#1]

Hello, I'm new in QlikView and I have a question:

I create a table:

Client type	D-7 (ACHAT)	D (ACHAT)	Var (ACHAT)	D-7 (VENTE)	D (VENTE)	Var (VENTE)
Type1	1 703 337	12 468 611	632,01%	590 700	919 400	55,65%
Type2	1 577 234	1 978 485	25,44%	150 000	311 800	107,87%

I want to add 2 columns ACHAT and VENTE:   

	Achat			Vente
Client type	D-7	D	Var	D-7	D	Var
Type1	1 703 337	########	632,01%	590 700	919 400	55,65%
Type2	1 577 234	1 978 485	25,44%	150 000	311 800	107,87%

Can you help me? Thanks in advance. Best regards, Rym

[sudhir0538]

Hello rym.

You want to add new column or you want to merge the first column?

[er_mohit · Accepted solution]

Hi,

You can achieve the same by using valuelist function.

Try search on google

For you report you have to add dimension with click on add calculated dimension and write

valuelist(ACHAT,VENTE)

On expression side:

write in expression if (Match(valuelist(ACHAT,VENTE),ACHAT),then , else)

Hope it helps

[#4]

Thank you so much for you help