Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to check the values of last few days in an expression

Hi ,

I am new to Qlikview . Could you please guide me on

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.

eg . say n =5 , show alarm on current day when there are alarm( count>0) for last 4 days also.

1 Reply
Anil_Babu_Samineni

May be this?

Count({<date = {"=Count(date) > 0"}>} alarm)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful