Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hello rym.
You want to add new column or you want to merge the first column?
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
Thank you so much for you help