Date Ranges

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a expression which calculates the percentage value

=num(if(sum(if(match(Fileld1,value1' ) and match(field2,'value 2') ..... etc),1,0))>0,

sum(if(match(Field1,'value1' ) and match(field2,'value2') ....etc,1,0)))

sum(IF(match(field1,'value1' ) and match(field2,'value2') ...etc ,1,0))*100,'#,#00.00')

now i want this expression to return values such that when I select a month [DateField1]= 1st of selected month and [DateField2]= Maxdate of selected month.

Thanks in advance

topic Date Ranges in QlikView

Date Ranges