Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Add product quantity to all products after a specific date

Hello,

I'm very new to Qlik and while I was able to learn a lot in the last weeks, I need some help with a task.

1. I have a simple chart that takes e.g. stock.date as dimension and =Sum(stock.qty) as measure.  I also have a variable called vStockAdd, which I can change on-fly thanks to an extension. The variable holds a number of stock I need to add at or after a specific date in stock.date.  If I change the chart measure to =Sum(stock.qty + $(vStockAdd)) , everything works and the value of vStockAdd is added to stock.qty, but how can I do this so it adds vStockAdd at a specific date or to all dates after a specific date? I hope it makes sense (no pun intended). 

2.  The above + add it to specific product at or after a specific date? Let's say I have stock.ProdID with values like Prod1, Prod2, Prod3, etc. However it will also be a variable - vStockProdID, which I could then change on-fly to manipulate the chart. 

 

Any help would be appreciated. 

0 Replies