Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date Ranges

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

0 Replies