Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to ignore some filters

I use the following expression in order to ignore year , month week and day filters , but when I choose a year the values change . How to modify it ?

((Sum({<Promo ={0},DateTest={">=$(=Date(Today() - 30)) <$(=Date(Today()-2))"},Year=,Month=,Week=,Day=>} [Prix de vente TTC]))/28 )*  count(distinct Date)

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

((Sum({<Promo ={0},DateTest={">=$(=Date(Today() - 30)) <$(=Date(Today()-2))"},Year=,Month=,Week=,Day=>} [Prix de vente TTC]))/28 )*  count({{$ <Year=,Month=,Week=,Day=> }distinct Date)


let me know

View solution in original post

1 Reply
alexandros17
Partner - Champion III
Partner - Champion III

((Sum({<Promo ={0},DateTest={">=$(=Date(Today() - 30)) <$(=Date(Today()-2))"},Year=,Month=,Week=,Day=>} [Prix de vente TTC]))/28 )*  count({{$ <Year=,Month=,Week=,Day=> }distinct Date)


let me know