Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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))