Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Wallibee
Contributor III
Contributor III

master item expression

Hi

I am trying to show turn over figure  for some dimensions 

Type of organisation 

Organisation 

Sales channel 

Type of customer

I would like to compare this with time dimension for example 

last year 

last week 

Yesterday 

How can I calculate this given a Net price and  using master Items for easy self service .

Thanks 

2 Replies
Chanty4u
MVP
MVP

try this

 

  InWeekToDate(Date, WeekEnd(Today()), -1) as Lastweek,

 Date(AddYears(Date, 1)) as lastyear,

  Date(Today() - 1,'DD/MM/YY') as yesterday

Wallibee
Contributor III
Contributor III
Author

thanks for the responds @Chanty4u 

I am trying to do this in the front end( Dashboard) using master items so I can show turn over figures compared to my Date dimension . if possible ideas on set analysis in my expression