Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

fix filter

Hi there,


Im my model I would like to have a fix filter on one sheet , regardless of what the user is choosing, The only field that change will be the date field.


example ...


I want to do the sum always when Cores is <=4  but when Status is base then sum Processor *.20 and when Status is New then just sum processor. But I want the values to change based on the date the user selected


sum(if(cores <=4, processor * if(Status='Base',0.20,if(Status='New',1,1))))

1 Reply
Gysbert_Wassenaar

Try something like: sum({1<Date=p(Date)>}if(cores <=4, processor * if(Status='Base',0.20,if(Status='New',1,1))))


talk is cheap, supply exceeds demand