Discussion Board for collaboration related to Creating Analytics for QlikView.
in my model i have a straight table ,
i want to present dims and expression that will respond to user selection and one expression that will calculate previous month value based on current selection .
created a field in script as below :
AddMonths((MakeDate(xyear,xmonth,01)),-2) as the_prev_date,
and in the table expression :
it retrieves the correct value , but it changes all the dims and expressions to the previous month disregarding selections ..
any ideas ?