Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
shayraber
Creator
Creator

generic set analysis for minus operation

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

1 Reply
petter
Partner - Champion III
Partner - Champion III

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))