topic Concat lastYear same day in QlikView

Concat lastYear same day

Fri, 12 May 2017 12:40:58 GMT

Hello,

i have a calender and i select in year 2015 und month 01 and day 01.

i have variable with

='(' &'Actuelldate:'&
Concat ({< BUDAT1 ={">=$(vMinimum) <=$(vMaximum)"}>} distinct BUDAT1,'|:')& '|Lastyear:'& Concat ({< BUDAT1 ={">=$(vMinimum) <=$(vMaximum)"}>} distinct BUDAT1,'|Lastyear:')
& ')'

vMinimum = =date(min(Date))

vMinimumVJ = =date(addmonths(vMinimum,-12))

vMaximum = =date(max(Date))

vMaximumVJ = =date(addmonths(vMaximum,-12))

if i select on year and month in calender, variable Show only Actuelldata and LastYear is the same.

Thanks

Shideh

Re: Concat lastYear same day

sunny_talwar — Fri, 12 May 2017 15:49:11 GMT

What is that you want to see for VvarSelect?

Re: Concat lastYear same day

Anonymous — Fri, 12 May 2017 15:52:19 GMT

your set analysis is the same for both years. should be

='(' &'Actuelldate:'&
Concat ({< BUDAT1 ={">=$(vMinimum) <=$(vMaximum)"}>} distinct BUDAT1,'|:')& '|Lastyear:'& Concat ({< BUDAT1 ={">=$(vMinimumVJ) <=$(vMaximumVJ)"}>} distinct BUDAT1,'|Lastyear:')
& ')'