Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've got an answer for a set analysis issue I've faced.
See last replay on this thread:
https://community.qlikview.com/thread/197277
Can anyone help me trying to make it generic?
10x
Shay
You can put the expression into a variable and put in parameters to parameterize it so it becomes a function:
LOAD SCRIPT:
vNew = 'Concat(DISTINCT {$<Customer = P({<EntryMPeriod = {$1}>})>-<Customer = P({<EntryMPeriod = {$1}>})>} Customer,'',''');
Used like this in an expression in your app:
=$(vNew(201510,201511))