Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
bengan74
Contributor III
Contributor III

Add monthly value to dates

Hi everyone!

I have a table with target values for HitRate for each store, month and year that I like to add to each date within the month.

TempHitrate:

YearMonthShopHitRate
2014jan10066%
2014feb10068%
2014mar10065%
2014apr10068%
2014may10067%
2014jun10068%
2014jul10064%
2014aug10067%
2014sep10068%
2014oct10069%
2014nov10068%
2014Dec10066%

I'd like to create a table with new field, Date (generated in the same way as in QV calender-script), and add Shop and the value from the field HitRate in the table TempHitrate above so the result looks like this:

Hitrate:

DateShopHitRate
2014-01-3010066%
2014-01-3110066%
2014-02-0110068%
2014-02-0210068%

So the field Date matches with the correct month and year in the first table, and adds the value for HitRate.

Is there anyone who know how to solve this I'm very greatfull!

Brg Johan

11 Replies
Anonymous
Not applicable

Something like below,

month_text.PNG.png

bengan74
Contributor III
Contributor III
Author

Thank you all for great help with this issue!

/Brg Johan