This content has been marked as final.
Show 1 reply
-
Re: combining columns and removing duplicates
Petter Skjolden Jan 11, 2018 1:56 PM (in response to SABINA Balan)By transforming the source customer table of 6 rows by 5 columns into a 24 rows by 3 columns it will be easier to create the logic to pick the right promo for each customer:
LOAD SCRIPT:
Then using a Pivot Table and the expression
SubField( Concat({<Code={"*15","*16*","*17"}>} Code,'|' , -Right(Code,2) ) ,'|' , 1 )
for the Final Promo measure you can get this:
I have attached a QVF Qlik Sense application that these screenshots are taken from...
-
# QC - 2018-01-11 Promo.qvf 192.0 K
-