Qlik Community

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report
Highlighted
esuper21
New Contributor III

Create Increment on Matching Fields

Hello -- need help on creating a weekly increment for an app.

The idea is to create a key based on a combination of 3 fields from original load and save that in a qvd file. Then the next week reload that data again and add '+1' if the combination stays the same. If the previous combo is not loaded in, then dropped from new stored qvd file for this week. If new, added as one to the qvd this week.

Example:

Week1: 

NAMECOLORNUMBER
EricaPurple5
MitchBlue20
WilliamGreen7

.. combos would be (Erica|Purple|5), (Mitch|Blue|7), etc.

Week2:

NAMECOLORNUMBER
EricaPurple5
MitchBlue6
WilliamGreen7
GraceYellow21

** only two of the week2 combinations are constant

Counts on the sheet for Week2 should show:

COMBOCOUNT
(Erica|Purple|5)2
(William|Green|7)2
(Mitch|Blue|6)1
(Grace|Yellow|21)1

 

The first "Mitch" record has been dropped and the new added to start at count of 1 again. 

I currently am trying a concatenate on saved qvd files, but having issues on adding the combo where it already exists. IS there a better way to do this?