reading a filter and setting a second filter dynamically based on the first filter

[Maike1]

I have this code:

view: salesPurchase_meas {

extension: required

filter: currYearTmp {type: string suggest_dimension: year }
filter: prevYearTmp {type: string suggest_dimension: year }

dimension: currYear {type: yesno hidden: yes sql: {% condition currYearTmp %} ${salesPurchase.year} {% endcondition %} ;; }
dimension: prevYear {type: yesno hidden: yes sql: {% condition prevYearTmp %} ${salesPurchase.year} {% endcondition %} ;; }

#dimension: prevYear1 {type: string hidden: no sql: ${TABLE}.year;; filters: [currYear: "yes"]}

dimension: nnt_tmp1 {hidden: yes type: number sql: ${TABLE}.nnt ;;}

measure: nnt_ac {type: sum sql: ${nnt_tmp1};; filters: [currYear: "yes"] value_format_name: decimal_0}
measure: nnt_py {type: sum sql: ${nnt_tmp1};; filters: [prevYear: "yes"] value_format_name: decimal_0}

}

I want to make the filter prevYearTmp dynamically because it's always the selected value from currYearTmp -1
can you help me please ?

[Rhountu]

Hi @Maike1  Will the code  shown below help you out?

sql: {% condition prevYearTmp %} Date_add(${salesPurchase.year}),Interval -1 year  {% endcondition %} ;