Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

Move value to a different week in set analysis

Hi all, 


I would like to have values move in the week dimension of a table.  As an example if a supplier grants 30,60,90 days more or less payment terms, to see what effect that would have in the cashflow per week.  


So : if vAdditionalSupplierTermDays variable is set to 30, we should add 30 days to the date so that the corresponding cash value is moved further out 4 weeks.  I have the following set analyis.  It shows the values, but there is no shift in weeks.  

Sum({<InvoiceType={'Supplier Invoice','Customer CN'},