Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Applying Multiple Labels To My Data

Hi,

I have a more complex version of the data below (more catcodes/fields and 40 million rows of data):

DateLedgerBalance

CatCode1

CatCode2ObjectSubsidiaryCost Centre
31/01/2019AA1,0001001112120013000200
14/02/2019BB2,0002001112150033000200
22/10/2019CC3,0003002222169023001300

 

I have another data source which holds the labels (in a google sheet and I use Qlik Web connectors, so the users can update the Labels/CatCodes)

The data is a more complex version of below (100s of labels and more cat codes/fields):

LabelSort OrderBoldCatCode1CatCode2ObjectSubsidiary
Sales1NULL100111ALLALL
Cost2NULL200111215003
Total3YALL111ALLALL

ALL = Any value in this field

I need to join the labels to my transactional data in an efficient way (my successful results take over 5 hrs so far... e.g. filling in the ALLs with all available cat codes creates a huge table or applying the labels with hard coded resident loads for each one takes 30 seconds or so each and there are hundreds of labels... )

The result is to look something like below:

DateLedgerBalanceCost CentreLabelSort OrderBold
31/01/2019AA1,0003000200Sales1NULL
14/02/2019BB2,0003000200Cost2NULL
31/01/2019AA1,0003000200Total3Y
14/02/2019BB2,0003000200Total3Y
22/10/2019CC3,0003001300   

 

Any advice is appreciated.

Thanks,

Dean

 

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Creator
Creator

We have solved this by adding ALL to the other side of the table also, thanks for your response

View solution in original post

2 Replies
Highlighted
Contributor II
Contributor II

Hi,

How are you getting the codes, you are joining the two tables or linking them.

Kindly share your script.

Highlighted
Creator
Creator

We have solved this by adding ALL to the other side of the table also, thanks for your response

View solution in original post