Discussion Board for collaboration on QlikView Scripting.
Colleagues, good day!
Is in QV any solution to make field with two moth periods, in which every month includes two periods?
I need to make field (by date field) with such values:
Many thanks for every advice!
Have you got date field?
Create something like below..
Dual(Month(Date) & '-' & Month(AddMonths(Date,1)) ,Month(Date)) as YourDualMonthField
Is this This Month - Next Month or Last Month - This Month?
Yes. I have date field.
Field YourDualMonthField , example (Jan-Feb) get only January dates, but i need Jan & Feb dates
Which one of the two?
ThisMonth - NextMonth
LastMonth - NextMonth?
It must be not flag, but field with two month period names.
For example, today date (09.02.2016) must include Jan-Feb and Feb-Mar.
Something like below?
Load * Inline
Load Distinct Date, Month(Date) & '-' &Month(AddMonths(Date,1)) as Flag Resident Data;
Load Distinct Date, Month(AddMonths(Date,-1)) & '-' &Month(Date) as Flag Resident Data;
It doesn't work.
Your dates are text values, not proper date values. Convert them to proper numeric date values and then Manish's logic will work.
When you load the dates, you need something like:
Date#(Date, 'dd/MM/yyyy') As Date,