Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
ilanbaruch
Contributor III

set analisys with dates

hi all,

 

in my model i have two dates one is used for the master calendar (Date)

and the second is a transaction reference date (ValueDate)

i want an expression that ignores Date Field, and calculates by all smaller ValueDate 's from possible Date

i.e when model's data set include year 2018, and user selected April-18, calculation should include Jan-18 to Apr-18

 

advanced thanks

Labels (3)
1 Solution

Accepted Solutions
Partner
Partner

Re: set analisys with dates

hi 

it should be something like 

sum({<Date,ValueDate={"<=$(=max(Date))"}>}Sales)

2 Replies
Partner
Partner

Re: set analisys with dates

hi 

it should be something like 

sum({<Date,ValueDate={"<=$(=max(Date))"}>}Sales)

ilanbaruch
Contributor III

Re: set analisys with dates

Thank you Liron!
my final :
sum({$<Date=, ValueDate= {"<=$(vPossibleDates)"} > } Sales)
vPossibleDates=Date(max(ValueDate))