topic Re: Add Column in table in QlikView

Add Column in table

Wed, 15 Jun 2016 08:56:10 GMT

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

I create a table:

I want to add 2 columns ACHAT and VENTE:

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

sudhir0538 — Wed, 15 Jun 2016 11:48:48 GMT

Hello rym.

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

er_mohit — Wed, 15 Jun 2016 11:54:13 GMT

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

Wed, 15 Jun 2016 12:11:24 GMT

Thank you so much for you help