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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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:')
  & ')'