Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Concat lastYear same day

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

2 Replies
sunny_talwar

What is that you want to see for VvarSelect?

Anonymous
Not applicable
Author

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:')
  & ')'