Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
hope somebody can help me with this:
I have a table with the following columns: Customer, Type of Operation and Value.
I want to create a table with the following columns: Customer, Type A Operation, Type B Operation.
Type A and B are the different type of operations which can appear in the column Type of Operation in the original table. The value of of that field should be the sum of value by customer, if Type of Operation is either A or B. I tried it with "if", but it doesn't work. Please have a look at the attached example.
Thanks in advance,
Oliver
Hi Oliver,
just let QlikView know that you need the SUM of your values.
That´s all...
Rainer
there is no attachment?
Sorry for that. I had some trouble uploading it.
Here it is.
Oliver
Still doesn't work with the upload. Will try it from home later.
Oliver
Hope it works this time with the upload.
Oliver
Sorry for all these emails, but I can not upload any files. Not from work or home, different computers as well.
OK, the file is under my profile and called test. Sorry for all those emails and confusion, but for some reason I was not able to upload it.
Thanks in advance,
Oliver
Hi Oliver,
just let QlikView know that you need the SUM of your values.
That´s all...
Rainer
Hi Rainer,
that was easy, thanks for the help,
Oliver