Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
master_student
Contributor III

date dimension

Hello Guys,

I need your help.

I want to add a condition in my expression so that it will displays values of 2016 year until today

num(sum( {$<[Year of date]={$(=Max([Year of date])-1)}>}  RVN_AIRTIME),'# ##0')

4 Replies
Highlighted
devarasu07
Honored Contributor II

Re: date dimension

Hi,

You can try like this

num(sum( {$<[Year of date]={">=$(=Max([Year of date])-1)<=$(=Max([Year of date]))"}>}  RVN_AIRTIME),'# ##0')

Highlighted
master_student
Contributor III

Re: date dimension

no it didn't work, i would like that the dates of year 2016 would be until today 12/10 without displaying the year

Highlighted

Re: date dimension

Perhaps this?

num(sum( {$<[Year of date]={'$('<=' & =Today())'}, Year = {'$(=AddYears(Max(Year),-1))'}>}  RVN_AIRTIME),'# ##0')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted

Re: date dimension

Do you have any date field.