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.
Not applicable

Add Column in table

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

I create a table:

  

     

Client typeD-7 (ACHAT)D (ACHAT)Var (ACHAT)D-7 (VENTE)D (VENTE)Var (VENTE)
Type11 703 33712 468 611632,01%590 700919 40055,65%
Type21 577 2341 978 48525,44%150 000311 800107,87%

 

I want to add 2 columns ACHAT and VENTE:   

                   Achat                                    Vente
Client typeD-7DVarD-7DVar
Type11 703 337########632,01%590 700919 40055,65%
Type21 577 2341 978 48525,44%150 000311 800107,87%

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

1 Solution

Accepted Solutions
er_mohit
Honored Contributor II

Re: Add Column in table

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

3 Replies
sudhir0538
Contributor

Re: Add Column in table

Hello rym.

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

er_mohit
Honored Contributor II

Re: Add Column in table

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

Not applicable

Re: Add Column in table

Thank you so much for you help

Community Browser