Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

kakani87
Valued Contributor

Having a field with some details, now i want to consider total of multiple values as a new field value

Having a field with some details, now i want to consider total of multiple values as a new field value

let say, i have a field Product


Table with fields

Tab1:

Country

Product

Physician

Now data in Product filter available as  below

Product

Isentress

Tivicay

Intelence

Edurant

Reyataz

Prezista

Atripla

Eviplera

Stribild

Triumeq

Rezolsta

Evotaz

Genvoya

Odefsey

Symtuza

Juluca

Biktarvy

////// Expected data to Add in filter with the above details

Total darunavir

Total elvitegravir

Total elvitegravir

and i want to Add in Product filter as new values like (In backend script part need to be handled)

Total darunavir (Prezista+ Rezolsta+Symtuza)

Total dolutegravir (Tivicay+ Triumeq+Juluca)

Total elvitegravir (Stribild+ Vitekta+Genvoya)

Some one can help out of this

Regards,

Kakani.

stalwar1

tresesco

3 Replies
kakani87
Valued Contributor

Re: Having a field with some details, now i want to consider total of multiple values as a new field value

Kindly share the script as I'm having personal edition

Regards,

Kakani.

MVP
MVP

Re: Having a field with some details, now i want to consider total of multiple values as a new field value

Have a look here: Generic keys

dx_anupam
Contributor

Re: Having a field with some details, now i want to consider total of multiple values as a new field value

Hi Sai,

I think best way to achieve this is by using apply map load.

below link might help you out

Data Cleansing

Regards,

Anupam