Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. 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