topic Solved in QlikView

Solved

microwin88x — Thu, 05 Nov 2015 14:13:50 GMT

Solved

Gysbert_Wassenaar — Thu, 05 Nov 2015 14:22:55 GMT

LOAD

PERIOD,

VALUE

FROM

SOMEWHERE

WHERE

NOT WildMatch(PERIOD,'2015*') OR PERIOD = '201512'

;

microwin88x — Thu, 05 Nov 2015 14:41:31 GMT

Thanks, Gysbert! The thing is that I would need to do the same process for the next years (2016, 2017, etc)

Gysbert_Wassenaar — Thu, 05 Nov 2015 14:46:38 GMT

Then use

WHERE

WildMatch(PERIOD,'*12')

microwin88x — Thu, 05 Nov 2015 14:52:05 GMT

Perfect! I'll give it a try. Thanks!

Mark_Little — Thu, 05 Nov 2015 15:05:32 GMT

Hi,

I am guessing I miss understood what you were wanting as the above will only load the where the period ends in 12.

Just as I was was working on this before the correct answer popped up, I thought I would post this anyhow

This would give you the table shown above, i.e. period 12 for complete years and then monthly period for the current or incomplete years.

Mark