topic Re: Merging 2 field values to a new field value in QlikView

Merging 2 field values to a new field value

pradeep92 — Thu, 22 Nov 2018 04:04:49 GMT

Hi, I have different products say A,B,C etc.. I have requirement to have A , B and c is the new field value that should have the data with the sum of A and B. How do we do this ?

Re: Merging 2 field values to a new field value

AshutoshBhumkar — Thu, 22 Nov 2018 04:16:33 GMT

Hi, Can you provide some example ?

Re: Merging 2 field values to a new field value

pradeep92 — Thu, 22 Nov 2018 04:22:17 GMT

Hi, I have given groupement details in a table .. Eg : Amelia,surpharm,totalfrance, rostra, zentiva are the field values in a FIELD called GROUPEMENT. So the user is making selections on field values and the data is coming correctly . Recently we added a totalfrance field value where it should contain the data for both summing up Amelia and surpharm when totalfrance is selected in listbox.

Re: Merging 2 field values to a new field value

jonathandienst — Thu, 22 Nov 2018 05:29:37 GMT

Probably the best way to achieve this is to create another grouping field, associated with GROUPEMENT, which associates totalfrance with the two GROUPEMENT values that you require. The other GROUPEMENT values in the new group would simply associate with the same value.

Something like

LOAD *
Inline
[
   GROUPEMENT, NEW_GRPOUPEMENT
   rostra, rostra
   zentiva, zentiva
   totalfrance, totalfrance
   Amleia, totalfrance
   surpharm, totalfrance
   ...add more...
];

Now use the new field in the listbox place of GROUPEMENT.

Re: Merging 2 field values to a new field value

pradeep92 — Thu, 22 Nov 2018 05:34:00 GMT

Hi,

Thanks for the input . So this will sum up the data for total France but I should be having the other groupement as well separately . Please guide me on this scenario as well ?

Re: Merging 2 field values to a new field value

jonathandienst — Thu, 22 Nov 2018 05:36:41 GMT

Not sure what you mean. Do you want to be able to select the components of totalfrance separately? Then you will need 2 listboxes, one for each of the groupings.

Re: Merging 2 field values to a new field value

pradeep92 — Thu, 22 Nov 2018 05:42:35 GMT

Hi,
Actually I would like to have the “totalfrance” field value along with zentiva,anemia,suropharm etc in the same listbox. We don’t have any data for totalfrance. But it should show the data for sum of anemia and suropharm when selected from listbox.

Please let me know if you need more details

Re: Merging 2 field values to a new field value

pradeep92 — Thu, 22 Nov 2018 08:01:49 GMT

A new field value is added to the same file where in totalfrance should contain the sum of 2 already existing field values

Re: Merging 2 field values to a new field value

pradeep92 — Thu, 22 Nov 2018 11:25:17 GMT

Hi,

I want the output like

LOAD *
Inline
[
   GROUPEMENT, NEW_GRPOUPEMENT
   rostra, rostra
   zentiva, zentiva
   totalfrance, totalfrance // Should contain both sum of AMLEIA and SURPHARM data
   Amleia, // AMELIA OLY
   surpharm, t// SURPHARM oly
   ...add more...
];