topic Re: Insert data based on conditional date variables in App Development

Insert data based on conditional date variables

AT84Qlik — Fri, 14 Dec 2018 14:12:25 GMT

I have a list of projects, which are all due to be delivered on a specific date, and which all have a specific size of people working on them.

When I do tables + sum the size by date, it will only display the size on that specific date. What I want, is a table which shows all of the months from Jan-Dec 19 (column headers), and anywhere the date stamp in my source table is less than those months, to sum the size value from the table.

I have tried setting vJan, vFeb as variables + then trying to calculate distance from those dates + estimated delivery date as another variable, I've tried running cross table to mix dates + size, and I've tried entering interval match but I don't understand it + it doesn't like the code. If anyone can help me figure out a way to do this, it would be much appreciated, as have spent weeks on this so far and I'm completely lost

Re: Insert data based on conditional date variables

Gysbert_Wassenaar — Fri, 14 Dec 2018 17:34:26 GMT

Perhaps like this: sum(size * Round( DayNumberOfYear([specific date])*12/365.2425))

Re: Insert data based on conditional date variables

AT84Qlik — Mon, 17 Dec 2018 15:16:20 GMT

Thanks Gysbert - I tried adding this as a master dimension though and it says it's invalid, even though the syntax help said the expression was 'OK'

I think that's the problem though, I don't know where to put this to get it to work, should it actually be a variable? or a Load script?

Re: Insert data based on conditional date variables

Gysbert_Wassenaar — Tue, 18 Dec 2018 07:16:23 GMT

That's because it's not a dimension. It's a measure. You can't use that expression as a dimension. Please post a small qlikview .qvw document or a qlik sense .qvf app that explains what you're trying to do.