Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: fix filter

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
Community Browser