topic How to check the values of last few days in an expression in QlikView https://community.qlik.com/t5/QlikView/How-to-check-the-values-of-last-few-days-in-an-expression/m-p/1400865#M797095 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I am new to Qlikview . Could you please guide me on</P><P>I have a table with date range as a dimension and a column with the alarm count on that date. I dont want to create a chart where alarms will be shown for all dates . I want alarms to be shown if there are say n continous days of alarm.</P><P>eg . say n =5 , show alarm on current day when there are alarm( count&gt;0) for last 4 days also.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z How to check the values of last few days in an expression https://community.qlik.com/t5/QlikView/How-to-check-the-values-of-last-few-days-in-an-expression/m-p/1400865#M797095 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I am new to Qlikview . Could you please guide me on</P><P>I have a table with date range as a dimension and a column with the alarm count on that date. I dont want to create a chart where alarms will be shown for all dates . I want alarms to be shown if there are say n continous days of alarm.</P><P>eg . say n =5 , show alarm on current day when there are alarm( count&gt;0) for last 4 days also.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-check-the-values-of-last-few-days-in-an-expression/m-p/1400865#M797095 Anonymous 2020-11-25T16:16:04Z Re: How to check the values of last few days in an expression https://community.qlik.com/t5/QlikView/How-to-check-the-values-of-last-few-days-in-an-expression/m-p/1400866#M797096 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><STRONG>Count({&lt;date = {"=Count(date) &gt; 0"}&gt;} alarm)</STRONG></P></BODY></HTML> Fri, 15 Dec 2017 02:29:16 GMT https://community.qlik.com/t5/QlikView/How-to-check-the-values-of-last-few-days-in-an-expression/m-p/1400866#M797096 Anil_Babu_Samineni 2017-12-15T02:29:16Z